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?
