When you’re authenticating a data source in My Pro Metrics, 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.
Instructions #
One of the fastest ways to solve these errors is to renew the connection between myprometrics 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 renew 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, My Pro Metrics can encounter issues when the browser you’re using is logged into more than one Google Account.
Follow these instructions to learn how to manage Supermetrics and multiple Google Accounts.
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:
Apple Safari
Google Chrome
Microsoft Edge
Mozilla Firefox
Destination troubleshooting #
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 My Pro Metrics.
Google Sheets #
- Open the My Pro Metrics 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.
- In the Home tab of the My Pro Metrics sidebar, scroll down to Templates and workflow, and click Refresh all queries.
Looker Studio #
- Reauthenticate the data source.
- Log out from the data source platform and reconnect.
Excel #
Follow these steps to solve the No queries found error.
The Your administrator has not installed Web Add-ins for your organization error 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.
