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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
jack_kennedy
Frequent Visitor

Native Queries Issue for Azure Databricks / Spark : "Native Queries aren't supported by this value"

Hi,

 

I am trying to get Native Queries to work in Power Query against an Azure Databricks or Spark Connector and I keep hitting this error:

 

jack_kennedy_0-1620858941474.png

 

 

Does anyone know if this is simply because Native Queries arent support against Databricks?

 

Thanks a lot for your help.

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

Hi, @jack_kennedy 

 

Native queries are support for Databricks.
Generally, if custom SQL queries cannot be run against the source, the Native Query function is not available.

 

For reference:

Power BI Native Query and Query Folding 

Using Azure Databricks to Query Azure SQL Database 

Querying Azure SQL Databases In Databricks Spark Cluster 

A beginner’s guide to Azure Databricks 

 

 

Best Regards,
Community Support Team _ Zeon Zheng
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

4 REPLIES 4
Anonymous
Not applicable

Hi all,

I found the solution. 
https://docs.databricks.com/en/partners/bi/power-bi.html
It is not documented in any Microsoft literature as far as I can find.


You create your connection to Databricks like you would normally do with the Databricks.Catalog connection.  Then just change Databricks.Catalog to Databricks.Query.  You will get a function you can put in your SQL query.

wallace13_0-1693508363624.png

then you can enter your query, the final result would look something like this in the advanced editor:

let
  Source = Databricks.Query("xxxxxxxx.azuredatabricks.net", "/sql/1.0/warehouses/xxxxxxxx", [Database = null, EnableAutomaticProxyDiscovery = "disabled", Catalog = "xxx"])("SELECT * FROM xxxxx)
in
  Source




v-angzheng-msft
Community Support
Community Support

Hi, @jack_kennedy 

 

Native queries are support for Databricks.
Generally, if custom SQL queries cannot be run against the source, the Native Query function is not available.

 

For reference:

Power BI Native Query and Query Folding 

Using Azure Databricks to Query Azure SQL Database 

Querying Azure SQL Databases In Databricks Spark Cluster 

A beginner’s guide to Azure Databricks 

 

 

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

HashamNiaz
Solution Sage
Solution Sage

Hi !

 

Please go through the MS dcos;

 

Power BI - Azure Databricks 

Regards,

Hasham

Thanks for the reply - however there is no mention of Native Query on that documenation

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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