Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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): 
Source = Odbc.Query("OriginName", "SELECT * FROM Origin.Table where CONDITIONS")

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

Status: New
Community Support