This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.
Log in to ask a question

Not Able to Copy Data Source Connected With Service Account Credentials

Posted on 02-14-2024 02:09 AM
shreya_kothaval
Bronze 2
Bronze 2
Reply posted on --/--/---- --:-- AM

I have a data source connected with data tables using BigQuery connector. The data source uses service account credentials. And this data source is able to connect with table and show data fields properly.

When I try to create a copy of the same data source, I'm getting error while reconnecting the data source (even with the same GCP project and dataset as the original one). looker_studio_connection_error.png

But when I try to create a copy from any other data source which uses my personal credentials to connect with BigQuery. I'm able to create a copy of that one.

The service account and the looker service agent has all the required access as mentioned in the documentation.

1 1 89
1 REPLY 1

Posted on --/--/---- --:-- AM
lsolatorio
Staff
Reply posted on --/--/---- --:-- AM

Hi @shreya_kothaval, 

Welcome and thank you for reaching out to our community.

Your use case pretty much lies on the permission settings of your service account, please ensure that the roles assigned to both BigQuery and Looker are matching.

As best practice, please review your logs as it may provide you with specific errors or insights that can help you with your troubleshooting.

Consider exploring these resources as well as they can be of help.

 

0 Likes