Forum Discussion
Power BI Connection Error with BigQuery
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
This solution worked for me, (thanks!), however I am struggling to understand why this is suddenly neccessary on tables which worked fine previously? Do you have any insight on that?
