Reauthenticating a data source refreshes your license's connection to it. This can be helpful if you're encountering issues logging in, or if you need to make changes to your connected accounts.
This guide will walk you through how to reauthenticate the user account linked to a data source with Data Studio, Google Sheets, or Excel.
Instructions
Google Sheets Data Studio Excel
- Open a Google Sheets file.
- Click Extensions → Supermetrics → Launch to open the sidebar.
- Select a query that uses the data source you want to reauthenticate from the sidebar. Click the 3-dot menu next to its name.
- Click Manage data source connection.
- In the data source list, click the chevron next to the data source's name.
- Click Log out all.
- Authenticate the data source again.
If you're using an older version of Supermetrics, skip step 3. Instead, just select the data source from the sidebar, and then follow steps 5 through 7.
- Open Data Studio. Click on the data source you'd like to reauthenticate.
If you're actively editing a report, click the Edit icon () next to your data source (or click Resource → Managed added data sources and click Edit there).
- On the left side, click Edit connection.
- Navigate to the link at the end of the sentence that starts with “To add more/manage user accounts…”
- Choose the team that the connection you'd like to authenticate belongs to.
- Click Reauthenticate (or, for some data sources, Reconnect).
- Authenticate the data source again.
Click Reconnect.
Click Done.
Remove a data source from Data Studio
- Navigate to Resource → Manage added data sources.
- Find the data source in the list that you want to remove and click Remove.
- Click Remove data source to confirm.
Revoke a data source in Data Studio
- On the top sidebar, click Add data.
- Find the data source’s name with "by Supermetrics" beneath it.
- Click the three-dot menu on the card to open the options menu.
- Click Revoke access.
- Click Remove to proceed.
- Click Remove anyway to confirm.
- Open an Excel file.
- Click Data → Show Supermetrics. If you're actively editing an existing query, navigate to Query → Stop modifying.
- Click on the Cross (X) next to the data source name.
- Click Ok.
- Authenticate the data source again.
Troubleshooting
- If you encounter one of the Google errors below, follow these instructions.
- This action is not supported when you are logged with multiple accounts
- This was a reauthorization request for user X but you logged in as user Y
- If you encounter the error "No accounts selected", it means you haven't selected any accounts when authenticating the data source. To fix it, go back to the data source settings, and under Select accounts/locations/views, select at least one account.