How to re-authenticate an Excel connector

In some cases, you may need to re-authenticate your user account to the data source for the connector. The below instructions show you how to do this, using Facebook Ads as an example (these same steps work for all connectors).

  1. Select an empty cell in the Excel file, one that has no query data in it. 
  2. Under the Data tab, click Show Supermetricsto open the sidebar.
    • If the sidebar is already open, make sure you are not editing a query. Click "Stop modifying" to exit editing.

      Orange arrow points to blue link text to "Stop modifying" which will exit the query editing mode.

  3. Click Data Source to expand the list.
  4. Under the "My data sources" section, find the data source that you need to re-authenticate. This example will look for Facebook Ads.

    Note that there can be multiple accounts listed and the data source can appear multiple times. You may need to do these steps for all logged in users for that source to ensure all user logins are refreshed correctly.

  5. Click the "X" next to the data source(s) to remove that user.

    Orange Arrow pointing to X icon to remove the data source login

  6. You will see a warning asking to confirm that you want to remove this account. Queries that used this account will stop working momentarily, but the next steps are to log in again so they will work again once that is complete. Click OKto continue.

    Orange arrow points to blue OK button to confirm the user will be removed and the queries that used that account will stop working (until you log in again)

  7. If you have multiple user accounts for the data source, repeat steps 5- for each account before proceeding.
  8. Scroll down into the "Add data source" section and find the data source you just removed in the list.
  9. Click on it to start the authentication process. This example is looking for Facebook Ads as that was the account that was logged out.

    Orange box around the example Facebook Ads data source to log back in.

  10. A new window will open and walk you through the steps to authenticate the data source. Complete the steps and close the window when prompted.

    WARNING - For some sources, like Facebook or Twitter, it will use the browser cookies to log the user in automatically, which can sometimes lead to the wrong user being added. If you need to prevent this, you will need to log out of the data source in the browser (for example, log out of your Facebook account in the Facebook site), and then click on the connector name to start the login process. It should then prompt you for a username and password to that source instead of using the already logged in account.

  11. If you have multiple user accounts that need to be logged in, repeat steps 8-10 for each account.
  12. Refresh the queries that used this connector to verify the re-authentication was successful.

Did you find it helpful? Yes No

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