blog post

Error on Looker Studio : The account ID is not available.

Johan Chemin
October 10, 2023
Error on Looker Studio : The account ID is not available.

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

What is the error: The account ID is not available.

Sometimes in Looker Studio, all your components display an error message. When you click on See details, this is what you get :

The account ID: XXX is not available. Please go to https://app.catchr.io/data-connector/sources, and look for your data source.

An ID replaces the XXX (it could be only numbers or letters and numbers, depending on the platform linked to it).

That means your account (with the given id) is unavailable in your Catchr Sources. Therefore, Looker Studio cannot find it in the data source, and it cannot display your dashboard because it cannot access the data.

What can you do?

You can solve this easily by refreshing your access authorization. To do so :

  • Go to https://app.catchr.io/data-connector/sources.
  • Find the row with your platform.
  • Click Edit.
  • Click on Refresh your authorization.
  • Wait for your account to appear on the page.
  • Go back to your report and refresh it. This can take a few minutes to be effective, so if it does not work immediately, wait for a little and refresh it again.

If you still have the error message, you need to reconnect your data source in Looker Studio :

  • Go to Resources, Manage added data sources. 
  • Click Edit on the row of your data source, then click Edit connexion at the top left.
  • Check that the dropdown selector has your account name in it. If it doesn't, click on it and select it.
  • Click on Reconnect at the top right.
  • Close the pop-up and refresh your report.

If the list is empty on the connexion page on Looker Studio, that means that your account is not available in the Catchr Sources. Please go to https://app.catchr.io/data-connector/sources and try to add a new source.

If the account does not appear, check the last paragraph of this article.

Why does it happens?

There can be various reasons why your authorization was revoked. The first two are :

  • You change your password on the platform. When you created your access on Catchr, it was with the previous one. It would help if you refreshed your authorization so we can have the new one.
  • There was a risky operation on your platform account, so the access is revoked on all third-party applications for security reasons. You also need to refresh it manually.

How to avoid

The best way to avoid your report being unavailable is to check regularly that your Catchr Sources are OK. You can check their status on this page: https://app.catchr.io/data-connector/sources : 

Catchr Sources list and status.
Catchr Sources list and status

The Success sync status means that Catchr has successfully synchronized your account (there is a refresh every 30 minutes).

The X account available means that we found X accounts to whom you have access in your platform account.

The status is OK, but I still have the error. What do I do?

If your account still does not appear in the list of the Catchr source and the status is on success, there can be several main reasons :

  • You do not have enough rights on the account -> For all platforms, you need to be an admin to link an account to a tierce service. Please, check if you are the administrator.
  • You are trying to link the wrong account -> Log in to your platform with the right account, then return to Catchr and try to link your new source again.
  • Copy the account ID in the error message, and look for it in your platform account. If it does not appear, Catchr won't be able to find it.

If you tried everything explained here and your report still has the error, don't hesitate to contact us at contact@catchr.io or on our chat, and we will find a solution.

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.