How to Reconnect Data Source in Looker Studio

Seeing your meticulously crafted Looker Studio dashboard break because of a failed data connection is incredibly frustrating. Instead of valuable insights, you're greeted with error messages like "Data Set Configuration Error." This article will show you exactly how to reconnect your data source and get your reports back online, covering fixes for both embedded and reusable data sources.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Why Do Data Sources Break in Looker Studio?

A failed connection can happen for several reasons, and it's rarely your fault. Usually, something has changed in the background either with your credentials or with the original data's structure. Understanding the common causes can help you diagnose and fix the problem faster next time.

Here are the usual culprits:

• Expired Credentials: For many platforms, especially ad platforms like Google Ads or Facebook Ads, the authentication you provide isn't permanent. These "tokens" expire after a certain period for security reasons, and you simply need to grant Looker Studio access again.
• Password Changes: If you've updated the password for an underlying account (like the Google account linked to your Analytics or Google Sheets), Looker Studio will lose access. The old password it had on file is no longer valid.
• Changes in the Source Data Itself: This is one of the most common issues when using Google Sheets. If you rename a header, delete a column that a chart was using, or change the name of the worksheet tab itself, Looker Studio will be unable to find the data it expects.
• Permission Revoked: The user account that originally connected the data source might have lost permission to access the data. This happens frequently in organizations when roles change or a user is removed, their authorization goes with them.
• The Data Source Was Moved or Deleted: If your report is connected to a specific Google Sheet, for example, and that file is deleted or moved to a different folder you don't have access to, the connection will break.

A Quick but Important Distinction: Embedded vs. Reusable Data Sources

Before diving into the fix, you need to know which type of data source you're dealing with. Looker Studio has two types, and how you reconnect them is slightly different.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Embedded Data Sources

An embedded data source is created "inside" a single Looker Studio report and is tied only to that report. Any changes you make to its connection are self-contained and won’t affect any other reports. Think of it as a local, one-time-use connection. They are perfect for quick, specific reports where you don't plan on reusing the same data setup elsewhere.

Reusable Data Sources

A reusable data source is a standalone item that is created separately and can be added to multiple different reports. The big advantage here is consistency, you set it up once, and every report that uses it pulls from that same exact source with the same calculated fields and configurations. When you update or fix the connection for a reusable data source, the fix applies to every report connected to it. This is much more efficient if you're using the same Google Analytics property or sales database across multiple dashboards.

How to check? In your report, go to the top menu and click Resource > Manage added data sources. In the table that appears, look at the "Type" column. It will clearly state whether a source is "Reusable" or "Embedded."

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

How to Reconnect an Embedded Data Source (Step-by-Step)

Fixing a broken embedded data source is done entirely within the report having the issue. Your goal is to get to the connection settings and re-authorize or update them.

1. Open Your Report: Navigate to the Looker Studio report that is showing the errors.
2. Manage Data Sources: Go to the menu bar at the top of the screen and select Resource > Manage added data sources.
3. Find the Broken Source: A window will pop up listing all the data sources connected to your report. The one that's causing trouble will likely have a visible error message or be a clear suspect if your charts reliant on it are broken.
4. Edit the Connection: To the far right of the data source's name, you'll see several actions. Find and click the Edit link. This will take you to the data source editor view, where you see all your metrics and dimensions.
5. Click to Reconnect: At the very top left of this editing screen, you’ll see the details of your connection. There will be a blue link that says Edit Connection. Click it.
6. Re-establish the Connection: A new panel will slide out from the left. This panel shows the exact parameters Looker Studio is using to connect (e.g., the specific Google Sheet and worksheet). Here, you will see a big blue button labeled Reconnect. Click it.
7. Follow the Authentication Prompts: Looker Studio will now ask you to re-apply the configuration. This might involve a pop-up window asking you to choose your Google Account and grant permission again. Be sure to select the account that has direct access to the underlying data.
8. Apply and Update: Once you grant permission, a window might appear showing changes to the fields (for example, if a column name changed). Review these changes and click Apply at the bottom. Once you're back in the main data source editor, click Done in the top-right corner, then Close the data source manager. Your charts should begin repopulating with data almost immediately.

How to Reconnect a Reusable Data Source (Step-by-Step)

Since reusable sources are independent items, you fix them from the main Looker Studio homepage, not from inside a report.

1. Navigate to Data Sources: Go to the Looker Studio home screen (https://lookerstudio.google.com/). On the left-hand navigation menu, click on Data Sources.
2. Find Your Data Source: You'll see a list of every reusable data source you've created. You can use the search bar at the top to find the one you need to fix by name.
3. Open the Data Source Editor: Click on the name of the broken data source. This will open it in the same editor view you see when creating a new source.
4. Edit the Connection: In the top left corner, just under the data source name, click the Edit Connection link.
5. Reconnect and Re-authorize: Just like with the embedded source, the connection panel will appear from the left. Click the Reconnect button and follow the prompts from Google to re-authorize Looker Studio's access to your data.
6. Apply and Save: Carefully review any proposed schema changes and click Apply. Once finished, click Done in the top-right corner. This fix will now instantly propagate to every single report that uses this data source.

Troubleshooting Common Errors After Reconnecting

Sometimes, simply reconnecting isn't enough, especially if the structure of your data has changed. Here's how to handle the most common follow-up errors.

Error: "Schema Mismatch" or "Fields Were Removed"

This is the classic Google Sheets issue. It means you renamed a column, deleted a column, or added new ones. Looker Studio expects the data to be in the same format it was when you first connected it.

• The Fix: In the data source editor view (Resource > Manage added data sources > Edit), look at the bottom left-hand corner. You will see a button that says Refresh Fields. Click this. Looker Studio will re-scan your source data (the Sheet, BigQuery table, etc.) and update its list of available fields. It will show you a summary of what's been removed, added, or changed. Approve the changes, and most of your charts should be fixed. You may need to manually update any charts that were specifically using a field that was deleted or renamed.

Error: Charts Still Show "Invalid Metric/Dimension"

This frustrating error happens even after you reconnect and refresh fields. It means a specific chart is still trying to use a field name that no longer exists.

• The Fix: Click on one of the broken charts in your report. On the right-hand panel, inspect the "Dimension" and "Metric" fields. You'll see a red, invalid field. Simply click on it, and choose the correct, new field from the updated list. You'll need to do this for each chart that was using the old field name.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Error: "You Do Not Have Access to the Underlying Datasets"

This is a pure permissions problem. The Google account you're using does not have viewer or editor rights for the source - whether that's Google Analytics, a BigQuery project, or a shared Google Sheet.

• The Fix: There's no fix within Looker Studio itself. You (or the data owner) need to go to the source platform and grant your Google Account the necessary permissions. Once you have access to the Google Sheet or GA4 property directly, head back into Looker Studio and click the "Reconnect" button again. This time it will work.

Final Thoughts

Fixing a broken data source connection in Looker Studio typically boils down to identifying whether the source is embedded or reusable, then navigating to the correct menu to re-establish the connection. The process is straightforward, but it highlights the constant maintenance required to keep manual marketing and sales dashboards running properly.

I found myself spending a lot of time re-authenticating connections across multiple dashboards. That's one of many reasons why we built our tool, as it streamlines this entire process. With Graphed, I just connect my data sources like Google Analytics, Shopify, and Google Ads once. It handles the connections, APIs, and credentials securely in the background. Now, instead of hunting down broken sources, I can just use plain English to build real-time dashboards and get answers instantly without any connection upkeep.