The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Solved! Go to 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.
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:
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.
Thanks for the reply - however there is no mention of Native Query on that documenation
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
135 | |
114 | |
108 | |
71 | |
57 |
User | Count |
---|---|
240 | |
129 | |
122 | |
96 | |
94 |