How to Change the Data Source in Looker Studio Reports

Q: How do I add a new data source to my report?

To add a new data source, go to the Resource menu, select 'Manage added data sources', and click on 'ADD A DATA SOURCE'. From there, you can connect to a new data source.

Sotirios Seridis

2 min read

Wondering if you can add multiple data sources to Looker Studio reports? The answer is yes! You can add various types of data sources such as Google Analytics, Google Ads, Google Sheets, and more to your Looker Studio reports. You can apply these data sources to individual elements, multiple elements, or even the whole page of the report. This quick and easy guide will show you how to change the data source in Looker Studio reports!

➡️🎥 Check our YouTube Channel for more Looker Studio Tutorials!

➡️ Say something nice! or ask me anything!✨💬

How to Change the Data Source for One or Multiple Looker Studio Scorecards, Charts or Tables:

Select an Element
You can select all the elements of the same kind to change the data source simultaneously.
Under the SET-UP column, click on Data Source
Click on "Add Data"
Select the Data Source and click on "Add"

How to Change the Data Source for the entire Looker Studio Page:

Click on Page (top menu)
Navigate to Current Page Settings
Under the SET-UP column, click on "Select Data Source"
Click on "Add Data"
Select the Data Source and click on "Add"

Frequently Asked Questions on Changing the Data Source in Looker Studio Reports

Can I use multiple data sources in a single report?

Yes, Looker Studio allows you to use multiple data sources within a single report. You can add different data sources for different charts or sections of your report.

How do I add a new data source to my report?

To add a new data source, go to the Resource menu, select Manage added data sources, and click on ADD A DATA SOURCE. From there, you can connect to a new data source.

What happens to my report if I change the data source?

Changing the data source will update the report to reflect data from the new source. If the new data source has the same fields and structure, the charts should update seamlessly. However, if the new data source has different fields or data structures, you may need to reconfigure some charts, tables, or filters to align with the new data source.

What should I do if my charts show an error after changing the data source?

If your charts show an error after changing the data source in Looker Studio, you should check the following to resolve the issue:

Ensure that the new data source contains the same fields (dimensions and metrics) that your charts were using. If the fields are missing or have different names, update the fields accordingly.
Make sure that the data types in the new data source match what the charts expect. For example, if a chart is expecting a numeric value but the new data source has text, it will cause an error.
If your charts use filters or calculated fields, verify that these are still valid with the new data source. You may need to recreate or adjust these fields.

Will changing the data source affect shared reports?

Yes, if you change the data source in a report that has been shared, the changes will be reflected for all users who have access to that report. Ensure that the new data source is accessible to all users who need to view the report.