cancel
Showing results for 
Search instead for 
Did you mean: 

GoogleBigQuery.Database function

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?



Status: New
Comments
Community Support