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
Before you can reauthenticate a data source in Google Sheets, you need to install the Supermetrics add-on.
- Open a new Google Sheets file.
- Click Add-ons → Supermetrics → Launch to open the sidebar. If you're editing an existing query, navigate to Query→ Exit.
- Under Data source, click the chevron next to the data source name.
- Click Log out all.
- Click Log out.
- For guidance on how to log in again, see this category.
- Open this Data Studio link. Click on the data source you wish to authenticate.
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).
- Click Edit connection.
- Navigate to the link at the end of the sentence that starts with “To add more/manage user accounts…”
- Click Reauthenticate.
- For guidance on how to log in again, see this category.
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 dots on the card to open the options menu.
- Click Revoke access.
- Click Remove to proceed.
- Click Remove anyway to confirm.
Before you can reauthenticate a data source in Excel, you need to install the Supermetrics add-on.
- 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.
- To login again to a data source, see this category.
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.
