Not Able to Copy Data Source Connected With Service Account Credentials

Google Cloud Data Analytics
1

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
looker_studio_connection_error.png1362×356 30.8 KB

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 Like
2

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.