Open navigation

How to reauthenticate or remove a Data Studio, Google Sheets, or Excel data source

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
Before you can reauthenticate a data source in Google Sheets, you need to install the Supermetrics add-on.
  1. Open a new Google Sheets file. 
  2. Click Add-ons → Supermetrics → Launch to open the sidebar. If you're editing an existing query, navigate to Query→ Exit.
  3. Under Data source, click the chevron next to the data source name.
  4. Click Log out all.

  5. Click Log out.
  6. For guidance on how to log in again, 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.


Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.