Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
117 | |
75 | |
46 | |
45 | |
32 |
User | Count |
---|---|
172 | |
90 | |
66 | |
46 | |
45 |