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
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): letSource = Odbc.Query("OriginName", "SELECT * FROM Origin.Table where CONDITIONS")inSource
Is there a way to insert select statements into the Database function?
As far as I know, this is not yet supported.