Solved: Query Folding for Big Query?

Anonymous · ‎10-17-2019

Hi,

Does anyone have any success doing Query Folding with Google Big Query? I have tried installing the SIMBA driver locally and this seems to enable it, but with the BigQuery connector that exists in Power BI it doesn't seem to be working.

Anyone have any experience with this combination?

Best,

Ali A

Anonymous · ‎10-21-2019

Hi @v-frfei-msft

I have used that driver, but it doesn't allow Native Query so been installing a data gateway and will be testing with Simba ODBC driver for BigQuery to see if that helps 🙂 So far that looks good!

Thanks for the reply tho.

Best,

Ali A

View solution in original post

v-frfei-msft · ‎10-18-2019

Hi @Anonymous ,

Is that what you want?

https://docs.microsoft.com/en-us/power-bi/desktop-connect-bigquery

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Anonymous · ‎10-21-2019

Hi @v-frfei-msft

I have used that driver, but it doesn't allow Native Query so been installing a data gateway and will be testing with Simba ODBC driver for BigQuery to see if that helps 🙂 So far that looks good!

Thanks for the reply tho.

Best,

Ali A