Insufficient Permission in Looker Studio When Using My Own BigQuery + Google Sheets Data Source

Looker Q&A Looker
,
1

I’m currently using BigQuery as a data warehouse and joining it with a Google Sheet (which I own) through a SQL query. The resulting data source is then connected to Looker Studio.

I’m the owner of both the BigQuery query and the Google Sheet, and I also have admin-level access to everything.

However, when I connect this data source to Looker Studio, I get an “Insufficient Permission” error. Interestingly, the data loads without any issues when one of my colleague changes to his data credentials and only his credentials work. To provide more context, both of us have the same permission and access level. I have also tried with other colleagues but only that colleague’s credentials work.

Why is this happening to me even though I have full ownership and admin access? Is there a specific permission or credential setting I might be missing?

image
image275×174 1.86 KB

2 Likes
2

I’m struggling with the same issue

5

I can’t speak to how Looker Studio works, as I use Looker Original. We use Looker Original and BigQuery, and we use a service account to authenticate Looker requests to BigQuery. This is the process that we follow when using a Google Sheet as a data source in Looker:

  1. Create the sheet, and then give the service account view-access
  2. Create a table in BigQuery, using the Google Sheet as the source (‘Create table from’ = Drive, and ‘Select Drive UI’ = )
  3. Create a view in Looker that references the BigQuery table