Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.