How to connect power bi to google big query using direct query

[leviyabl]

I have most of my big tables (tables with over 200 M records) sitting at Google's Big Query servers and would like to use Power Bi (Desktop) for doing analytics. Found Simba´s ODBC driver, installed and configured and gained access to the datasets, but Power Bi is not giving a choice for Direct Querying the data. Instead, is trying to download it, which of course will not do it, firstly because of storage limitations on the client side, but mostly because the only reason I have the data at Big Query is to be able to use Google´s processing power. Simba´s driver specs says it should allow Direct Querying (called Direct BI) but that did not work for me.
Has anyone out there ever tried to connect BQ from Power Bi? If so could direct querying? Have any ideas or suggestion for doing this without transferring the data?

Thank you

[v-yuezhe-msft · Accepted solution]

@leviyabl,

Please use the native Google BigQuery connector to connect to your source. This connector allows you to easily create reports on top of Google BigQuery databases by using DirectQuery mode.



Regards,
Lydia

[Jancarlos_Ascen]

Is there a local gateway for updating data from the power bi service?