Using Native SQL while connection the Google BigQuery

[idan189]

Hey,

I'm super new to Power BI and want to start working with it, but it seems that i can no do something that should be super easy.

I'm trying to import data from my Google BigQuery DB, but i dont want to import the entire tables into Power Bi, but a table that is the output of a SQL query.

How can I do it? I know it should be very easy, but somehow the only option i see is to import the entire table.

Thanks,

[v-cherch-msft]

Hi  @idan189

You may try to create a ODBC data source for BigQuery.Here is the blog for your reference.Below is the similar post.

https://community.powerbi.com/t5/Integrations-with-Files-and/Connection-to-BigQuery/td-p/459928

Regards,

Cherie