Forum Discussion

Michieldo's avatar
Michieldo
Helper III
3 years ago

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

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-Access-Denied-BigQuery/ta-p/1906046

 

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?


1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    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.