Forum Discussion
Unable to connect BigQuery on PowerBi Application
Hello,
When I connect to my BigQuery on PowerBI Desktop and try to pull data from one of the largest projects(having over 200 datasets with 30,000 date partitioned tables) under Bigquery, I get the error below.
Used features: Odbc.DataSource/Microsoft ODBC Driver for Google BigQuery/2.4.0.1002/BigQuery
I tried clearing the cache in powerbi application folder(C:\Users\username\AppData\Local\Microsoft\Power BI Desktop\Cache) and it doesn’t work for me.
Could you please help me with this.
Hi NetElixir ，
Please review the content in the following links and try the method inside to connect to BigQuery:
1. Compact and repair database
power bi error container exited unexpectedly with code dxc0000374.
2. Write native query in Advanced Options
Power BI BigQuery – A Step-by-Step Connection Guide
How to connect BigQuery to Microsoft Excel and other apps with our new ODBC driver
Best Regards
1 Reply
Hi NetElixir ，
Please review the content in the following links and try the method inside to connect to BigQuery:
1. Compact and repair database
power bi error container exited unexpectedly with code dxc0000374.
2. Write native query in Advanced Options
Power BI BigQuery – A Step-by-Step Connection Guide
How to connect BigQuery to Microsoft Excel and other apps with our new ODBC driver
Best Regards