How to Remove Data from Looker Studio

Managing data in Looker Studio is a regular part of keeping your reports clean, fast, and accurate. Whether you're phasing out an old data source, cleaning up test connections, or simply tidying your workspace, knowing how to properly remove data is essential. This guide will walk you through a few different ways to remove data, from disconnecting a source in a single report to deleting it from your account entirely.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Understanding Data in Looker Studio: Reports vs. Data Sources

Before you start deleting things, it's important to understand the relationship between your reports and your data sources in Looker Studio.

• Reports: This is the visual dashboard you create with charts, tables, and scorecards. It's the final product that you and your team interact with.
• Data Sources: This is the bridge connecting your report to your raw data. When you connect Looker Studio to Google Analytics, a Google Sheet, or a BigQuery table, you create a dedicated "Data Source" layer. This layer can be reused across multiple reports.

This separation is powerful because it lets you use one managed data source across dozens of reports. However, it also means you need to be careful. Removing a data source from one report is different from deleting the reusable data source itself, which could break all reports connected to it. Let's break down each method safely.

Method 1: Removing a Data Source from a Specific Report

This is the most common task. You have a report that uses multiple data sources, and you want to remove one without affecting other reports. For example, maybe you transitioned all your charts from an old Google Sheet to a new BigQuery table and now want to clean up the unused connection.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step-by-Step Guide

1. Go into Edit Mode: Open the Looker Studio report you want to modify and click the "Edit" button in the top right corner.
2. Open Data Source Management: Navigate to the menu and select Resource > Manage added data sources. This will open a panel showing every data source connected to your current report.
3. Identify and Remove: Find the data source you want to get rid of in the list. On the far right, you'll see an "Actions" column. Click the "Remove" option with the trash can icon.
4. Confirm Your Choice: Looker Studio will show you a warning message, such as "Removing this data source may break charts." This is your final chance to double-check that you're removing the right one. Click "Remove Data Source" to proceed.

Once you confirm, the connection between that data source and your report is gone. Any charts or controls that were relying solely on that data will now show an error. It's good practice to delete these broken components to keep your report clean.

Pro Tip: Identify Which Charts Use the Data Source First

To avoid unexpectedly breaking parts of your report, find out which charts depend on the data source before you remove it. Go to Resource > Manage added data sources. In the "Used in Report" column, Looker Studio tells you how many charts are connected to each source. If it says "0 charts," you can safely remove it without breaking anything active in the report.

Method 2: Completely Deleting a Data Source from Your Looker Studio Account

Sometimes you need to permanently delete a reusable data source from your entire account, not just from a single report. This is a more definitive action and should be done with extra care.

When should you do this?

• The underlying data is gone (e.g., a deleted spreadsheet or a decommissioned database).
• It was a temporary or test data source you no longer need.
• You've created an improved, master version and want to retire the old one to avoid confusion.

Step-by-Step Guide

1. Navigate to Data Sources: Go to the main Looker Studio homepage.
2. Find Your Source: Make sure you’re on the "Data sources" tab. You can use the search bar to find the specific data source you want to delete.
3. Initiate Removal: Hover over the data source name and click the three-dot menu (⋮) on the right. Select "Remove" from the dropdown menu.
4. Final Confirmation: Looker Studio will present a strong warning, explaining that deleting a reusable data source is irreversible and will permanently break any reports that rely on it. You'll need to type the name of the data source into a confirmation box to proceed, ensuring you don't do this by mistake.

**Heads up:** This action cannot be undone. Always triple-check which reports are using a data source before you permanently delete it. You can do this by opening the data source from the homepage and checking which reports it's connected to in the top menu.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Method 3: Filtering Data Instead of Removing It

Often, "removing data" doesn't mean deleting the source but rather excluding specific information from your charts. For instance, you might want to remove internal traffic from your website analytics or exclude test orders from your sales reports. In these cases, a filter is the best solution. Filtering is non-destructive and highly flexible.

How to Add a Filter at the Report Level

A report-level filter applies to all charts in your report, providing consistency without configuring each chart individually.

1. In "Edit" mode, go to File > Report settings.
2. In the settings panel that appears on the right, click "Add a filter" under the "Report-level filter" section.
3. Configure your filter rule. For example, to exclude traffic from your home country, you might set a rule to: Exclude > Country > Equal to (=) > "United States"
4. Click "Save." The filter immediately applies to the entire report.

How to Add a Filter at the Chart Level

If you only want to exclude data from one specific chart, apply a chart-level filter.

1. Click the chart you want to modify to select it.
2. In the "Setup" panel on the right, scroll down to the "Filter" section.
3. Click "Add a filter" and define your inclusion or exclusion rule as you did before.

Using filters preserves your data source connection while giving you precise control over what your audience sees.

Troubleshooting Common Data Removal Issues

Sometimes things don't go as planned. Here are a few common issues and how to fix them.

Why is the "Remove" button grayed out?

This almost always happens because you don't have the necessary permissions. To remove a data source, you need to have "Editor" access to the report. If you're listed as a "Viewer," you won't be able to make any changes to the report's structure, including its data connections.

"My charts are broken after removing a data source!"

If you accidentally removed a data source that your report still needed, you have a couple of options:

• Use Undo: If you just did it, the quickest fix is to use the "Undo" command (Ctrl+Z or Cmd+Z).
• Re-add the Data Source: If it's too late to undo, you can go to Resource > Manage added data sources and click "Add a data source." Reconnect to the source, and then manually re-link any broken charts by selecting the new source from their individual configuration panels.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What does "Data Set Configuration Error" mean?

This common error usually indicates a problem with the underlying data's permissions, not with Looker Studio itself. It often appears after a data source was removed and re-added, or if the credentials used to connect to the data are no longer valid (e.g., someone who set up the connection left the company). To fix it, go to Resource > Manage added data sources, click "Edit" on the problematic source, and in the top left, click "Reconnect." This will typically prompt you to re-authorize the connection with valid credentials.

Final Thoughts

You've now learned how to remove data from Looker Studio by disconnecting sources from reports, deleting them entirely from your account, and filtering out unwanted data - while also being able to troubleshoot common errors. Properly managing your data sources is key to maintaining clean, reliable, and easy-to-manage dashboards, so keep these methods handy whenever you're doing a bit of report spring cleaning.

While mastering Looker Studio is powerful, managing dozens of connections and manually cleaning up reports can become a chore, especially when you pull data from different marketing or sales platforms all at once. At Graphed, we designed a system where you don't have to think about this at all. Just connect your platforms like Google Analytics, HubSpot, or Shopify with a few clicks, and our AI does the heavy lifting. Instead of building charts and managing data sources, you simply ask in plain English for what you want to see, and Graphed creates a real-time, interactive dashboard for you instantly.