Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
@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
Is there a local gateway for updating data from the power bi service?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.