Forum Discussion

CarlosPBIVision's avatar
CarlosPBIVision
New Member
3 years ago
Solved

Power BI Connection Error with BigQuery

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...
Need Help
  • CarlosPBIVision's avatar
    CarlosPBIVision
    3 years ago

    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,

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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