Forum Discussion
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 because Native Queries arent support against Databricks?
Thanks a lot for your help.
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.
4 Replies
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:
letSource = Databricks.Query("xxxxxxxx.azuredatabricks.net", "/sql/1.0/warehouses/xxxxxxxx", [Database = null, EnableAutomaticProxyDiscovery = "disabled", Catalog = "xxx"])("SELECT * FROM xxxxx)inSourceThanks for the reply - however there is no mention of Native Query on that documenation
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.
