Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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()?
Solved! Go to Solution.
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.
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.
User | Count |
---|---|
17 | |
10 | |
9 | |
9 | |
8 |
User | Count |
---|---|
23 | |
18 | |
15 | |
13 | |
13 |