Forum Discussion
Using odbc to connect PowerBI Desktop to BigQuery
Hi,
due to sampling using the Google Analytics API, I´ve changed to BigQuery for more complex Reports. For each day I have a raw data file located in BigQuery. I wrote a query to get all the data in a data range, which works perfectly fine. Now my question, if I use a wildcard for the "until date", does PowerBI pulls always all the data again or only the delta?
Thanks
Lina
1 Reply
v-sihou-msftMicrosoft Employee
Anonymous
Currently, we can only connect BigQuery via ODBC. So Power BI Desktop pulls data depends on the DSN you created. You can put SQL Statement in Advanced Option of DSN so that it will only retrieve data up to "until date".
Reference:
Author and Share Power BI Reports on Real-Time BigQuery DataRegards,