When you're authenticating a data source in Supermetrics, you might encounter these errors:
- Authentication failed.
- You need to reauthenticate at [data source] and then run the query again.
If this happens, follow the instructions below to diagnose and solve the issue.
One of the fastest ways to solve these errors is to reset the connection between Supermetrics and the data source triggering the error. When you're doing this, you should also check that your account's user role has the right permissions for the data source you're using.
When you're ready, reauthenticate the data source to reset the connection.
- Reauthenticate a data source connection in Looker Studio, Google Sheets, or Excel
- Reauthenticate a data source connection in data warehouse, API, or cloud storage platform
If reauthenticating doesn't solve the error, refresh your account list instead.
Like many third-party applications, Supermetrics can encounter issues when the browser you're using is logged into more than one Google Account.
Clearing your browser's cache and cookies can help to remove stale permissions that might cause errors when authenticating in Supermetrics.
Your browser's documentation should have instructions on how to do this. Here's documentation for a few common browsers:
If the error persists, it might be because the error is being triggered in your data destination. Follow the steps below for the product you're using with Supermetrics.
- Open the SupermetricsQueries tab.
- Find the row(s) for your data source's failing queries. Delete the query ID value in that row.
- Scroll to the far right and delete the row's value in the “Refresh with user account” column.
- Click Extensions → Supermetrics → Refresh all.
- To solve the No queries found error, follow these steps.
- The error Your administrator has not installed Web Add-ins for your organization often means that your Microsoft Office 365 system administrator has disabled an option that allows users to install add-ons. To fix this error, contact your system administrator to talk about your account’s permissions.