Problem Connecting Google Sheets with Google BigQuery and Using Power BI

[Ahmed_Ayman]

Hello,
I am facing an issue when trying to connect data from Google Sheets to Google BigQuery via the free version. I successfully created a dataset and linked it with Google Sheets. However, when trying to connect Power BI to the tables in BigQuery (which are linked to Google Sheets), I get the following error message:

"ODBC: ERROR [42000] [Microsoft][BigQuery] (100) Error interacting with REST API: Access Denied: BigQuery BigQuery: Permission denied while getting Drive credentials."

I need assistance in resolving this issue. Can you please clarify why this error occurs and how to fix it?

Thank you for your cooperation.

[mars124]

Try the suggestions from this post: https://www.googlecloudcommunity.com/gc/Databases/Big-query-error-on-Power-BI/m-p/649218