---
title: "How to fix '[User] needs to log in to data source as' error"
slug: "how-to-fix-user-needs-to-log-in-to-data-source-as-error"
description: "Fix Supermetrics query errors in Google Sheets by renewing data source connections or transferring ownership for seamless data refresh."
updated: 2025-11-03T12:24:51Z
published: 2025-11-03T12:24:51Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt
> Use this file to discover all available pages before exploring further.

# How to fix '[User] needs to log in to data source as' error

When you create a query in Google Sheets, your data source connection and subscription are used to fetch data — in other words, you become the **query owner** or **query editor**. Whenever anyone else refreshes the query, the query editor's login credentials will be used to refresh the query.

If you see the "`[User] needs to log into data source as...`" error, this means that Supermetrics couldn't find the original connection used in the query. This can happen, for example, because the query editor needs to reauthenticate or the query was edited manually and something went wrong.

To fix this, renew the connection to the data source if you're the owner of the query. If you're not the owner of the query, you can transfer the query ownership to you and refresh the query with your connection.

## Instructions

****If you are the query owner, renew the connection****

1. Click **Extensions → Supermetrics → Launch** to open the sidebar.
2. Go to the **Queries** tab.
3. Select a query that uses the data source you want to reauthenticate from the sidebar. Click the 3-dot menu next to its name.
4. Click **Manage data source connection**.
5. In the data source list, click the chevron next to the data source's name.
6. Click **Add connection** or **Add new user**.
7. [Follow our data source guidance to connect to the data source again](/v1/docs/connect).
8. Refresh the query.

****Transfer query ownership to you and refresh the query****

1. Create a new query using the needed connection.
2. Open the SupermetricsQueries tab (if hidden, click **Extensions → Supermetrics → Manage queries**).
3. Copy the value in the "Refresh with user account" column (column AU) from the newly created query.
4. Paste the copied value to all query rows you want to run using the new connection.
5. For each query to run with the new connection, delete the "Query ID" (column A) value in that query's row.
6. Once all the queries have been prepared, open the sidebar, scroll down to Templates and workflow, and click **Refresh all queries**. After you refresh, you'll see a new Query ID value in column A.