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

[jack_kennedy]

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:

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

Thanks a lot for your help.

[wallace13]

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.

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 · Accepted solution]

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]

Hi !

Please go through the MS dcos;

Power BI - Azure Databricks 

Regards,

Hasham

[jack_kennedy]

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