How to Delete Blended Data in Looker Studio

Trying to remove a blended data source in Looker Studio (formerly Google Data Studio) can feel like a strange puzzle. You know it’s no longer needed, but the "Remove" button is stubbornly grayed out. This quick tutorial will walk you through exactly why that happens and the step-by-step process for successfully deleting any blended data from your reports.

Graphed

Still Building Reports Manually?

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

Watch the Demo

What is Blended Data in Looker Studio?

Before we jump into deleting it, let's have a quick refresher on what a data blend actually is. In Looker Studio, data blending allows you to combine information from multiple data sources into a single chart or table. You do this by defining a common "join key" - a dimension that exists in all the data sources you want to link, like Date, Campaign ID, or Customer Email.

A classic example for marketers is blending data from Google Ads and Google Analytics.

• Your Google Ads data has metrics like Costs and Clicks.
• Your Google Analytics data has metrics like Sessions, Goal Completions, and Revenue.

By blending them together using Campaign Name as the join key, you can create a single table that shows Clicks, Ad Cost, Sessions, and Revenue all in one place, giving you a clear view of your return on investment (ROI).

So, Why Would You Need to Delete a Blend?

Data blends are incredibly powerful, but you'll often find yourself needing to remove them for a few common reasons:

• The Blend is Incorrect: You might have selected the wrong join key, used an incorrect join type (e.g., left vs. inner join), or the data just isn't matching up the way you expected.
• The Blend is No Longer Needed: The report's focus has shifted, and the combined chart you built is no longer relevant.
• To Improve Report Performance: Data blends can be resource-intensive and slow down your report's loading time. Simplifying your data sources by removing unnecessary blends can make your dashboard much snappier.
• You Want to Start Over: Sometimes it's just easier to delete a messy blend and rebuild it from scratch to ensure it's clean and accurate.

Graphed

Still Building Reports Manually?

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

Watch the Demo

The Core Problem: Why You Can’t Just Click "Remove"

The main reason you can’t immediately delete a blended data source is a protective feature built into Looker Studio. If a data source - blended or otherwise - is currently being used by any chart, table, scorecard, or even a filter control in your report, Looker Studio will prevent you from removing it. This is to stop you from accidentally breaking your report without realizing it.

The "Remove" option will be grayed out and unclickable. This tells you that something in your report is still connected to that specific blended data source. Your mission, then, is to find all the elements using that blend and disconnect them first.

How to Delete Blended Data in Looker Studio: A Step-by-Step Guide

Follow these steps to safely find and remove any unwanted blended data source. The key here isn't just deleting it, but detaching it from your charts without creating a chaotic mess.

Step 1: Identify Every Chart and Control Using the Blend

First, you need to play detective and find everything that’s connected to your blend. There are a couple of ways to do this.

The Easy Way: Use the "Manage added data sources" Menu

1. In Looker Studio, go to the menu at the top of the screen and click Resource > Manage added data sources.
2. A list of all data sources in your report will appear. Find the blended data source you want to delete. Its icon will look like two overlapping circles.
3. Look at the third column, titled "Charts." This will tell you exactly how many charts, tables, or other components are currently connected to that blend.
4. If the number is greater than zero, you know you have work to do. Unfortunately, Looker Studio doesn’t provide a clickable link to take you directly to those charts, so you'll still have to hunt for them manually, but this confirms that a connection exists.

Now that you know for sure the blend is in use, it's time to go find those specific charts and controls on your report pages and sever the connection.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 2: Change the Data Source For Each Connected Component

You need to go through your report page by page and click on each chart, table, scorecard, and filter. For each one, check its data source.

1. Click on a chart you suspect is using the blend.
2. Look at the Setup panel that appears on the right-hand side. The very first item under the "Data" tab is "Data source."
3. If you see the name of your unwanted blended data source there, you've found a culprit.
4. Click the name of the data source. This will bring up a list of all available data sources in your report.
5. Select a different data source from the list. For now, you can switch it to one of the original, non-blended sources. For example, if your blend used Google Ads and Google Analytics, you could temporarily change the chart's source to just your Google Ads data source.

**Important Note:** When you change the data source, the chart will most likely "break." You'll see an error message saying "Invalid dimension" or "Invalid metric." Don't panic! This is completely normal and expected. The chart is looking for fields that existed in the blend but don't exist in the new, simpler data source. The goal here isn't to fix the chart right now, but simply to disconnect it from the blend.

Step 3: Don't Forget to Check Filters!

This is the step that trips most people up. Even if you've changed the data source for all your visible charts and tables, a pesky filter might still be connected to the blend.

• Page-Level Filters: Check for any filters applied to the entire page. Go to Page > Current page settings. In the panel on the right, look for the "Data source" section to see if your blend is listed.
• Report-Level Filters: Check for any filters applied across your entire report. Go to File > Report settings and look for filters connected to the blend.
• Filter Controls: These are the interactive, user-facing dropdowns or search boxes on the report canvas itself. Click on each one and check its data source in the Setup panel, just like you did with the charts.

Hidden components can also be a cause. Make sure to check for any objects that might be layered behind other charts or on pages you don't use often.

Step 4: Finally, Remove the Blended Data Source

Once you are absolutely positive that the blended data source is no longer tied to any charts, graphs, tables, or filters, you can proceed with the deletion.

1. Navigate back to Resource > Manage added data sources.
2. Find your blended data source in the list. The "Charts" count should now be 0.
3. To the far right, the "Remove" button should now be blue and clickable.
4. Click "Remove."
5. A final confirmation pop-up will appear warning you that this action cannot be undone. Click the big blue "REMOVE DATA SOURCE" button to confirm.

Congratulations! You have successfully removed the blended data source from your Looker Studio report.

Troubleshooting Common Roadblocks

Still stuck? Here are answers to a couple of common sticking points.

Graphed

Still Building Reports Manually?

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

Watch the Demo

What if "Remove" is STILL grayed out?

If you've followed all the steps and the "Remove" button is uncooperative, it means you've definitely missed something. Go back and meticulously check every single element on every single page. The most common culprit is almost always a hidden filter control or a chart on a forgotten page.

What if I only want to EDIT the blend, not delete it?

If you just made a simple mistake in your blend setup, you don't need to delete it. You can edit it instead.

1. Go to Resource > Manage blended data.
2. Find your blend in the list and click "Edit" on the right.
3. This will reopen the data blending interface where you can adjust the tables, change the join keys, or modify the join type. All charts connected to the blend will automatically update with your changes.

Final Thoughts

Deleting a blended data source in Looker Studio is a bit indirect, but the logic is sound once you understand it. The key is to remember that you must first sever every connection between the blend and your report's components - charts, tables, and filters - before Looker Studio will allow you to remove it. With a little careful checking, you can keep your report's data sources clean and optimized.

We know that managing data sources, creating blends, and keeping reports up-to-date can be time-consuming. We've wrestled with these challenges ourselves, which is what led us to build Graphed. Our platform connects directly to all your sources like Google Analytics, Shopify, and Facebook Ads, letting you build dashboards and reports by simply describing what you need in plain English. Instead of manually configuring complex join rules, you can just ask a question, and our AI does the data bridging for you, getting you the insights you need in seconds, not hours.