How to reauthenticate a data source connection

1. Go to the Data sources page on the Hub and reauthenticate the connection for the data source you're having trouble with, following the steps above. AI chats and the Supermetrics MCP server use this Hub connection in the background.

2. In the AI chat or MCP host, find the Supermetrics integration and disconnect the integration.

3. Reconnect the Supermetrics integration to refresh the connection.

Troubleshooting

• If the AI tool doesn't recognize your active subscription after reconnecting, the connection might still be tied to a different email address. See this note on connections and subscriptions with AI tools to fix it.

• If reconnecting doesn't resolve the issue, the error message may not reflect the real problem. It can also indicate a licensing issue or a backend token problem, which can’t be fixed by reconnecting. Contact our support team if the connection still doesn't work after reconnecting.

1. Open a Google Sheets file.

2. Click Extensions → Supermetrics → Launch to open the sidebar.

3. Go to the Queries tab.

4. Select a query that uses the data source you want to reauthenticate. Click the 3-dot menu next to its name.

5. Click Manage data source connection.

6. Click the chevron next to the data source's name.

7. Click + Add connection.

8. Connect to the data source again.

Updating one query refreshes all queries that use the same connection.

If you're using an older version of the Supermetrics sidebar, skip step 3 and select the data source directly from the sidebar before following steps 6–8.

If the error persists in Google Sheets after reauthenticating:

1. Open the SupermetricsQueries tab.

2. Find the row for your failing queries. Delete the query ID value in that row.

3. Scroll to the far right and delete the row's value in the Refresh with user account column.

4. In the Home tab of the Supermetrics sidebar, scroll down to Templates and workflow and click Refresh all queries.

1. Open Data Studio and click the data source you'd like to reauthenticate. If you're editing a report, click the edit icon next to your data source, or go to Resource → Manage added data sources and click Edit.

2. On the left side, click Edit connection.

3. In the data source settings, click the link after View & manage your connections.

4. Select the team the connection belongs to.

5. Click the 3-dot menu and select Reconnect.

6. Connect to the data source again.

7. Click Complete and continue and Close this window to return to Data Studio.

8. In Data Studio, click Reconnect, then Apply and Done.

To remove a data source from Data Studio:

1. Go to Resource → Manage added data sources.

2. Find the data source in the list that you want to remove and click Remove.

3. Click Remove data source to confirm.

To revoke a data source in Data Studio:

1. On the top sidebar, click Add data.

2. Find the data source’s name with "by Supermetrics" beneath it.

3. Click the 3-dot menu on the card to open the options menu.

4. Click Revoke access.

5. Click Remove to proceed.

6. Click Remove anyway to confirm.

1. Open an Excel file.

2. Click Data → Show Supermetrics. If you're editing an existing query, go to Query → Stop modifying.

3. Open the Data source section.

4. Click the chevron next to the data source's name.

5. Click Add connection.

6. Connect to the data source again.

If you're seeing an Excel-specific error:

• Try switching to Excel Online.

• If you're seeing a No queries found error, clear the Microsoft Excel app cache.

• If you see Your administrator has not installed Web Add-ins for your organization, your Microsoft 365 administrator has disabled user add-on installation. Contact your system administrator to discuss your account permissions.

1. Go to Power BI on the Supermetrics Hub.

2. In the list of queries, click the data source you'd like to reauthenticate.

3. Click the query to see its details, then click the pencil icon to edit the query.

4. Navigate to the query connection details.

5. Click the trash can icon next to the connection to remove the old connection.

6. Click New connection and follow the steps in the data source connection guide to reconnect.

1. Go to the Data sources page on the Supermetrics Hub. If you're asked to select a team, select the team with the products and subscriptions you want to renew the connection for.

2. Find and click the data source with the connection you want to reauthenticate.

3. Find the connection in the list and click the reconnect icon at the end of the row.

1. Select the transfer you want to reauthenticate from the BigQuery data transfers page.

2. Click Edit in the top right.

3. Scroll down and click Change configuration.

4. Click Add another user.

1. On the Supermetrics Hub, go to API queries under Manage.

2. Find the data source you'd like to reauthenticate and click the chevron icon.

3. Select the account you'd like to reauthenticate.

4. Click the X icon, then click Disconnect.

5. Reconnect the data source.