CODEWITHSUNDEEP
google-bigquerylooker-studio
Visrut
Visrut

Reputation: 671

Looker Studio Viewer's Credentials is not working with Big Query resource

I have created a report in Looker Studio from my Big Query table and when I shared this report with [email protected] it worked as expected and recipient could see and edit the report perfectly.

Then for my data source inside data credentials, I changed the permission to Viewer's Credentials

enter image description here

After this, my report stopped working on the recipient side and showed this error:

enter image description here

I added the [email protected] inside my Big Query table so to make sure the recipient has access to data but still getting the same error. Also, there is a lot less documentation online regarding Viewer's Credentials so want to know if anyone has come across this issue.

enter image description here

In the above image, all of the roles have Principle with email [email protected]

Upvotes: 0

Views: 65

Answers (1)

gmw
gmw

Reputation: 151

Users need not only to be able to access to the data, but to run jobs as well.

Grant the users BigQuery Job User at the project level and then grant them BigQuery Data Viewer on the particular dataset which you want them to be able to see.

As an illustration, suppose [email protected] has BigQuery Job User in project-1 and BigQuery Data Viewer on project-1.dataset-a but not project-1.dataset-b. Suppose that you have a dashboard with one visualization from each dataset. [email protected] will see only the visualization from project-1.dataset-a.

Upvotes: 0

Related Questions