Unable to connect BigQuery on PowerBi Application

[NetElixir]

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.

[Anonymous · Accepted solution]

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

Running parameterized queries

Best Regards