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,
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?