You’re offline. This is a read only version of the page.
93
Hi everyone,
I'm hoping someone can point me in the right direction for using a native SQL query when connecting to Google BigQuery from Dataverse Dataflow. When I set up a connection on Dataverse, I don't have an option to provide a SQL query, only select existing tables/views that are then available individually in Power Query.
Contrast this to a standard SQL server connection, which offers a query input under the Advanced options:
Similarly, if I use BigQuery as my datasource in PowerBI Desktop, I can put in a query (as described here Use advanced power query editor to use SQL stateme... - Microsoft Fabric Community😞
Does anyone know if there is a way to add a native SQL query when using BigQuery via a Dataflow on Dataverse?
Documentation suggests it should be possible (Import data from a database using native database query - Power Query | Microsoft Learn) but I'm not seeing a means to do so when creating a Dataflow.
The BigQuery doc reference suggests this should be available on the web as well (Google BigQuery connector - Power Query | Microsoft Learn)
Am I simply missing something, or am I out of luck on this one?
Thanks!
Found a workaround. Even though the SQL statement input is not available as part of the connection setup on Web, you can drop in a native query once the connection is made in Power Query. Just create a new blank query and use the following format to get the query to run just as if you had the query input available on Desktop:
Value.NativeQuery(GoogleBigQuery.Database(){[Name="PROJECT NAME HERE"]}[Data], "SELECT STATEMENT HERE", null, [EnableFolding=true])
#1
mmbr1606
9
Super User 2025 Season 1
#2
stampcoin
7
#3
SD-13050734-0
6
Share
Report
All responses (
Answers (
