PowerBI Service connecting to Google BigQuery

[Jay_oleary]

When the PowerBI Service connects to Google BigQuery, there is an option to use the storage read api.  Under the covers, is the native connector integration using an ODBC driver such as Simba?  Or is the connection from the PBI service to Bigquery written natively in the PBI service to use the BQ Read API's directly?

[Anonymous]

Hi @Jay_oleary ,

Regarding your question, there is a direct connector for Big Query in Power BI. You can refer to the following article.

Google BigQuery connector - Power Query | Microsoft Learn

If you are using ODBC for connectivity in Power BI Desktop, you will also need to install the ODBC driver on the computer where the gateway is installed

Best Regards,
Wenbin Zhou