Problem Statement: We have multiple google data studio report that has a big query table as Datasource and the credential used to refresh the report is a specific developer's credentials (Why developer's creds? Because we can't grant all the users accessing report access to our table and authorized view also won't work because we need to add the users to group/add on demand )
And the issue with using developer creds is our organization has a cap on how much a user can query in bigquery for a project in a day, so if the developer has to run some heavy queries he can't because then if he reaches the limit the dashboards will fail.
The solution we thought of is using a Service account for Datasource refresh instead of any specific user.
Now the issue we are facing is we are not able to add the service account to refresh data source, we are getting below error
Data Studio's service agent is missing 'iam.serviceAccount.getAccessToken' permission for this service account
This occurs because our data studio service agent (Generated when you turn on API service in GCP) is missing the Token Generator role and I am not able to give the access to the agent facing the issue listed below.
Issue: Unable to use a service account to refresh bigquery data source in google data studio.
Actioned Steps:
Enabled data studio API for the project.
Provided required access to the service account to be used. Roles list: SA Access
Error: While using a service account as data credentials Error
Data Studio's service agent is missing 'iam.serviceAccount.getAccessToken' permission for this service account
Followed the steps here https://support.google.com/datastudio/answer/10835295?visit_id=637991541105883504-2056380779&p=sa-err-missing-role&rd=1#error-missing-role&zippy=%2Cin-this-article
According to documentation above, the below URL provides us the Service Agent's Details https://datastudio.google.com/serviceAgentHelp
Above URL gives blank page for me (Using organization Login) ServiceAgent Help Page
Do we alternative for getting Datastudio service agent details?