GoogleBigQuery.Database function

[Anonymous]

Hi everyone! 

I have an Issue, 

I'm new to Google Bigquery and trying to connect it to Power BI. I'm trying to not query the entire the table, but rather use a specific statement to filter columns with certain conditions

For example: 

SELECT * FROM 'TableAtSource'
where dateTable(dateColumn) between DATE1 and DATE2

Cloudera or Oracle databases allow the insertion of statements in the Source command in Power Query, but, I haven't figured out how to do the same using the GoogleBigQuery.Database function. 

What has previously worked (this is with Cloudera): 
let
Source = Odbc.Query("OriginName", "SELECT * FROM Origin.Table where CONDITIONS")
in
Source

Is there a way to insert select statements into the Database function?

[v-chuncz-msft]

@Anonymous 

As far as I know, this is not yet supported.

https://community.powerbi.com/t5/Power-Query/BigQuery-Connector-for-write-custom-SQL-Query-to-filter-Date-and/m-p/838933#M28094