Direct Query using ODBC driver on Google Bigquery

[songogeta32]

Hello, I am using Simba ODBC driver to query Google BigQuery tables in PowerBI Desktop application. I found its quite slow and to read just 300k records it takes hours and hours. Is there a way to make it faster or do direct query just like Google BQ connector instead of importing data first? Note the poweBi desktop application is running on a windows vm. 

```

`SELECT * FROM `abc`.`xyz`.`pqr`;

```

[Anonymous]

Hi @songogeta32 ,

Google Bigquery support the Direct Query mode, but if you have DateTime type date in your dataset, Direct Query mode may not be suitable:
Google BigQuery connector - Power Query | Microsoft Learn

Alternatively, you can consider the following ways to optimize performance:
1. Optimize Your Query: Ensure your query is as efficient as possible. Avoid selecting all columns if you only need a subset. Use WHERE clauses to limit the data returned.
2. Network Latency: Since your Power BI Desktop application is running on a Windows VM, network latency between your VM and Google BigQuery could be a factor. Check the network performance and consider optimizing it if possible.
3. ODBC Driver Configuration: Review the configuration settings of the Simba ODBC driver. Some settings might be adjusted to improve performance, such as increasing the fetch size or enabling/disabling certain performance features.

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[songogeta32]

Can you enable more on increasing performance in ODBC driver. What parameters we need to change?

So from ODBC driver there is no method to do direct query i.e. we compulsorily need to import data in powerBI desktop app?