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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
tctrout
Resolver III
Resolver III

Value.NativeQuery() with Azure Databricks

Looking for guidance on Power Query connecting to Azure Databricks using Value.NativeQuery()

I have read in other posts that Value.NativeQuery() will not work becuase Azure Databricks does not support native queries.  However, I know Databricks supports native queries as I was able to implement this: https://learn.microsoft.com/en-us/azure/databricks/integrations/bi/power-bi#using-a-custom-sql-query...

The above creates a function that allows you to paste in the desired sql statement. However, it does not allow subsequent applied Power Query steps to be folded.

I want to use Value.NativeQuery() so that the subsequent applied Power Query steps can fold back to Databricks.

I have tried multiple approaches and always receive the below error.
Below are the approaches I have tried, with variations of each. I used ||Pipe|| to mask names. Hoping someone can spot an error in my syntax?  Or insights why 1 method of Native Queries works but not the Value.NativeQuery()?

Error with Options.png

1 ACCEPTED SOLUTION
v-stephen-msft
Community Support
Community Support

Hi @tctrout ,

 

It seems that Azure Databricks does not support query folding currently.

Please check if you have transformations that prevent folding. If you don't have those transformations in Query folding - Power Query | Microsoft Learn and you can't see view native query in applied steps, it states the source don't support query folding for power bi. As for how to support, I suggest you create an idea for it in  Ideas  to improve the power bi.

Query folding on native queries - Power Query | Microsoft Learn

Similar post: Solved: Query folding - Databricks - Microsoft Power BI Community

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-stephen-msft
Community Support
Community Support

Hi @tctrout ,

 

It seems that Azure Databricks does not support query folding currently.

Please check if you have transformations that prevent folding. If you don't have those transformations in Query folding - Power Query | Microsoft Learn and you can't see view native query in applied steps, it states the source don't support query folding for power bi. As for how to support, I suggest you create an idea for it in  Ideas  to improve the power bi.

Query folding on native queries - Power Query | Microsoft Learn

Similar post: Solved: Query folding - Databricks - Microsoft Power BI Community

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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