Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I've had a group of 4 or 5 PowerBI Reports that have been working for months with no setting changes. All of a sudden today I am now getting an error stating ODBC: ERROR [42000] [Microsoft][BigQuery] (100) Error interacting with REST API: Access Denied.
None of my data will load, and the dataset I am retreiving is from DirectQuery in BigQuery.
Any suggestions?
Solved! Go to Solution.
FYI the solution ended up being in the Direct Query settings to set the billing project as the same name as the project you input for the Big Query settings.
Hi @teaguejs ,
If this issue only happens in Google BigQuery connector, have you tried to use ODBC connector to connect to the same table in the same source to check this issue, see:
Here is a similar thread that may helps you:
NEW BUG: Bigquery connection error - DataSource.Er... - Microsoft Power BI Community
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
FYI the solution ended up being in the Direct Query settings to set the billing project as the same name as the project you input for the Big Query settings.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.