Access Denied: BigQuery BigQuery: Permission denied while getting Drive credentials

[Michieldo]

Hi,

I have a similar problem as to what I could find in here:
https://community.qlik.com/t5/Official-Support-Articles/Qlik-Google-BigQuery-connector-error-quot-Ac...

So I have a Google Sheets which is synced to BigQuery. I have created a view in BigQuery, but when I try to get data from BigQuery in Power BI I receive the error: "Access Denied: BigQuery BigQuery: Permission denied while getting Drive credentials."

Anyone knows how to solve this in Power BI?

[Anonymous]

Hi  @Michieldo ,

Expired or inaccurate cached credentials can cause this issue. You can go to File | Options and settings | Data source settings and Try clearing the credentials for the data source from the Power BI desktop and re-editing.

You can check the official documentation for Power BI connection BigQuery to see if it is related to limitations and error messages:

Google BigQuery connector - Power Query | Microsoft Learn

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.