Forum Discussion

jack_kennedy's avatar
jack_kennedy
Frequent Visitor
5 years ago
Solved

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:       Does anyone know if this is simply becau...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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