Error updating data source credentials to use a Service Account

[rbvrr]

This post is a duplicate of this original post, by User 16641805288232090424. 

As that post was deactivated with no answer and the same problem is happening to me, I took the liberty to duplicate the post in this new Looker Forum.

1. Manage added data sources.

2. Click on the username next to `Data credentials`.

3. Select `Service Account Credentials` and enter a valid service account in the form {account_name}@{gcp_project_id}.iam.gserviceaccount.com.

4. Click `Update`.

After a minute or two an error is displayed, stating:

We have encountered an error updating your data source credentials. Please try again in a few moments.

The issue is consistent for 3 specific dashboards.

Data location: EU

The Service Account has read access at the Dataset level for all tables referenced in the Custom Query for the Data Source.

The Service Account has the BigQuery User role on the Billing Project.

The Service Account has been successfully assigned as Data Source Credentials service account on other boards by the same user (the user is the Project Owner).

The query executes without issues in the BigQuery console processing < 2Gb and completing in approx 30s. 

[rafa_3]

I am in the same situation.
I successfully updated the data source credentials for most data sources, but the same issue persists with a data source that has many columns.
And I noticed a 504 error(gateway timeout) in the console of the developer tools.

[christina_blake]

I'm seeing the same issue. I have successfully updated the same types of data sources using this same service account. Suddenly it is not working with the same process and data source.

It will load for a few minutes and give me the error message: We have encountered an error updating your data source credentials. Please try again in a few moments.

[meyerspod]

I am seeing the same issue on my end! 

[lindsay_lew]

I am also seeing the same issue when trying. 

[garman5]

I'm encountering the same issue. @sam8 could you assist here?

[sam8]

I'm unable to reproduce the problem, unfortunately.

I'll share it with the team and see if we're aware of any bugs or outages here, but no promises.

[garman5]

Thanks @sam8 

Please keep us updated on what your team says 🙂 

[garman5]

@sam8 I wanted to follow-up to see if there is a solution on this? Thank you!

[sam8]

The team has also not been able to reproduce this, nor find evidence of a widespread outage. The more people that post here, the more likely we are to find the root cause - so keep the reports coming!

[jayanne_azevedo]

I'm also seeing the same issue here!

[sam8]

If anyone who is experiencing this would like to help troubleshoot this - our engineers have asked for an ID of a data source where this is currently happening. You can get this ID by selecting the data source from the home page. Then, the URL should look something like this: https://lookerstudio.google.com/c/u/0/datasources/75048a49-7cb8-407f-a26f-29124e0f9896 

And in this example, the data source ID would be 75048a49-7cb8-407f-a26f-29124e0f9896 

[christina_blake]

@sam8 CC @garman5 I've done some more testing and found that I don't have the service account issue if I create a fresh report with one only data source and then try to use a service account. But I am having issues with existing reports and multiple data sources, where not all sources use the service account. Not sure if one of those items (existing report, multiple sources, not all sources use the service account) or all are factors.

@sam8 is there any way we can work on this over email (or even just share the data source ID over email)? I'd prefer not to share my data sources or service account email, etc...in a public thread if possible. You can email us at (PII Removed by Staff) and (PII Removed by Staff). 

[sam8]

Valid security concerns @christina_blake ! If anyone is experiencing this problem and doesn't want to share their data source ID in this thread, you can DM me your data source ID and I'll pass it on to our engineering team for troubleshooting.

[Douglas1987]

hi @sam8 !

Is there a solution for this topic? I'm still getting the same issue

[tongyu]

Hi @sam8 
We initially had the same issue, but was able to connect the Service account after a few refreshes/close and re-opens.
However after the connection, the dashboard is showing "Service account error", and I wasn't able to see any errors logged in the GCP project (in Org A). Any idea what could be the cause?
We have tried to connect the dashboard with a different Org service agent (in Org B) and the same service account (in Org A), just wasn't able to use the Service agent from the same org where the BQ GCP project is in. 

[sam8]

Eng is still investigating but hasn't confirmed this as a widespread issue. I definitely recommend reaching out to Cloud Support if you have access - they have a more direct line to engineering and can collect information that we can't really collect here on Community.