blog post

Looker Studio cannot connect to your dataset.

Johan Chemin
February 7, 2024
Looker Studio cannot connect to your dataset.

Quick steps to create a report with Google Sheets:

You can easiliy create a report following this step :

  1. Get informations from the data integration from our connector.
  2. Create a source on catchr.io.
  3. Download our Google Sheets extensions.
  4. Configure and run your request
If you need more informations, you can follow the tutorial.

How to install Google Sheets Catchr Add-on.

To start exporting your data to Google Sheets, you need to install the Catchr add-on. You currently have two options :

Option A: Via the marketplace:

  1. Visit the Catchr Add-on page on the Google Workspace Marketplace and click "Install."
  2. Grant the necessary permissions for the add-on.
  3. Upon successful installation, open a Google Sheets to proceed.
Connect Google Sheet to Facebook Ads
Install Catchr Google Sheets Add-on

Option B: Directly within a Google Sheets:

  1. Open a new Google Sheets.
  2. In the top menu, click "Extensions", then hover over "Add-ons" and select "Get add-ons."
  3. Search for "Catchr" and choose "Catchr - data connector."
  4. Click "Install" and grant the required permissions.
  5. Close the installation pop-up when completed.
  6. Start using the Catchr add-on.
Install Catchr Add-on for Google Sheets
Install Catchr Add-on for Google Sheets

Once you have installed the add-on, you can start making requests.

The tutorial

Quick steps to create a report with Looker Studio:

You can easiliy create a report following this step :

  1. Get informations from the data integration from our connector.
  2. Create a datasource and new report on Looker Studio.
  3. Choose your metrics and dimensions.
  4. Use charts with your metrics and dimensions.
If you need more informations, you can follow the tutorial. You can also find a template for at the end of the page.

The tutorial

Quick steps to create a report with PowerBI:

You can easiliy create a report following this step :

  1. Get informations from the data integration from our connector.
  2. Create a source on catchr.io.
  3. Configure your request on the PowerBI request manager.
  4. Copy the given URL in PowerBI
If you need more informations, you can follow the tutorial. You can also find a template for at the end of the page.

The tutorial

Looker Studio cannot connect to your dataset

If you end up here, you probably just found out a bunch of errors in your report. And when you check on more details, you just get this :

Looker Studio cannot connect to your dataset.

This happens when Looker Studio cannot find the underlying data sources and can be caused by several issues. Here is a step-by-step guide to follow to track them all.

Possible errors

  • Missing data source
  • Data set configuration error
  • No data set access
  • Data source not attached
  • Data source needs to be added
  • The underlying data has changed
  • Database connection error

How to fix ?

The first step is to check if the data source is rightfully attached to the component :

Click on the error component, locate his data source on the panel configuration, if it's broken, add the data source again. If the data source is already OK, go to the next step.

Refresh the data source list.

You can do that by going on : Resource -> Manage Added Data Sources -> Edit -> Refresh fields (button on the left bottom of your fields list).

Refresh your list fields on Looker Studio.
Refresh your list fields on Looker Studio.

Once refreshed, Looker Studio will display all the change made.

Check that the account is rightfully attached to the data source :

Edit the broken data source by going on Resource -> Manage Added Data Sources -> Edit -> Edit connection.

How to verify your data source ?
How to verify your data source on Looker Studio ?

Here is your connection to your account. The drop-down should contain the name of your account. If it is not the case, click on it and find your account.

Click on it and click Reconnect at the top right of the page.

Remove the data source and add it back :

For this one, you need to remove your data source from the report, then add it back. If you do not want to recreate everything, I strongly advise being sure your data source is reusable. If it's embedded in the report, you will have to recreate all your calculated field and rename all metrics you already renamed.

To check if a data source is reusable, got to Resource -> Manage Added Data Sources. In the column Type is your data source type. If it's reusable, it's OK, if not, go click on the Make this datasource reusable at the end of the row.

Then click on Remove to remove the data source from the report. Close the Manage Added Data Source panel and then click Add Data to re-add your data source.

Create a completely new one

If neither of the previous solution works, you can try to create a new fresh data source to see if it's working.

Database connection error

Lastly, you can remove the Looker Studio access to your Google account by going on https://myaccount.google.com/.

First verify that you are login with the right Google account. Then go on Security, scroll down to the Third-party app with account access, click on it.

Search for Google Data Studio / Looker Studio on the Google Apps section.

If none of the solution above works, feel free to contact us on our chat. We're happy to help you =)

No items found.

In this template, you will find all the metrics and dimensions you would need to get a better view of your data.

If you need more templates, you could look at our looker studio template gallery.

No items found.

In this template, you will find all the metrics and dimensions you would need to get a better view of your data thank to our integrations.

If you need more templates, you could look at our PowerBI template gallery.

Unlock Insights with Style!

Transform your marketing data into stunning dashboards.

Integrate, visualize, and impress with Catchr's seamless dashboards. Elevate your data game now!
Build your first report
14 days free-trial - No credit card required 🎉

More blog post about

No items found.