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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Syndicate_Admin
Administrator
Administrator

Dataflow in Dataverse with BigQuery - missing SQL statement option

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!

 

 

 

 

2 REPLIES 2
Syndicate_Admin
Administrator
Administrator

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])


Syndicate_Admin
Administrator
Administrator

Need to read a little further in the BigQuery connector doc to see that the SQL statement is not supported online:

Bummer 😞

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.