Permission error when sharing with other users in Looker Studio

[anaclaudia94]

Hi all! I'm designing some Looker dashboards that consume BigQuery data.
I have data from different tables, but they are all from the same project. Today when I went to send the invitations for access, colleagues got access but instead of graphs and tables, a box appeared with the following message:

"No access to dataset - Permissions are insufficient for the underlying dataset"

Could this be related to the project in Big Query?

I asked a person who has full access to the databases to view the dashboard and she also couldn't access the same charts, which made me a little confused about the permission issues

[Mehdi_Oudjida · Accepted solution]

@anaclaudia94 

You need to change the configuration of the related data sources to not use the viewer credentials but the owner ones, or better, configure a service agent for that.

To solve this, edit each data source, at the top, click on "data credentials", and switch to owner credentials.

For an organization, the better solution would be to configure a service account in Google Cloud, as described here

https://support.google.com/looker-studio/answer/10835295?hl=en#zippy=%2Cin-this-article

I hope it helps.

Mehdi

[anaclaudia94]

Thank you!! 😀

[EoinEoinEoin]

Why would you not be able to do this as an administrator?