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,
We have some reports that we expected to get refreshed on a daily basis on Power BI Service (all tables are connected to our data warehouse on BigQuery). But this morning, for some reason, we got this error for all of them:
ERROR [HY000] [Microsoft][BigQuery] (131) Unable to authenticate with Google BigQuery Storage API. Check your account permissions.
We already tried this thoroughly but it didn't work out: https://community.powerbi.com/t5/Service/BIgQuery-Account-Permissions/m-p/1390692
Does anybody know we could solve this? It seems it is happenning almost exclusively for the most heavy tables in terms of rows and size
Thanks
Solved! Go to Solution.
Hi Selina, we already solved the problem by contacting PBI Support directly.
To help future users: the solution was to go to the "Source" step of every PowerQuery table that we're ingesting from BigQuery, and substituting
Source = GoogleBigQuery.Database()
With
Source = GoogleBigQuery.Database([BillingProject = "Insert-Your-Project-ID-Here"])
That's it. The catch is that it must be for ALL tables coming from BQ, not only the large, problematic ones.
Best,
Hi Selina, we already solved the problem by contacting PBI Support directly.
To help future users: the solution was to go to the "Source" step of every PowerQuery table that we're ingesting from BigQuery, and substituting
Source = GoogleBigQuery.Database()
With
Source = GoogleBigQuery.Database([BillingProject = "Insert-Your-Project-ID-Here"])
That's it. The catch is that it must be for ALL tables coming from BQ, not only the large, problematic ones.
Best,
Hi @CarlosPBIVision ,
I'm glad you solved the problem. You can mark the reply as a solution to better facilitate other members to find it.
Best regards,
Community Support Team Selina zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @CarlosPBIVision ,
Have you had this error before? Have you tried to re-upload the report to the service for refreshing?
I reviewed the document you shared and indeed, there were errors consistent with yours and many members participated in it to share their views. but there is no solution to your problem, is there?
Best regards,
Community Support Team Selina zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
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.