Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello,
@developer @ad
Can someone assist me on how to write a Custom SQL in POWER BI Desktop? I have two tables from Data bricks and I wanted to write a custom SQL inside Power BI Desktop. I tried by going into the function bar, replace the function name Databricks.Catalogs with Databricks.Query. However, I received the error as Expression.Error: The name 'Databricks.query' wasn't recognized. Make sure it's spelled correctly.
Thanks in advance.
Solved! Go to Solution.
Hi , @Saran_T22
My Desktop Version: 2.109.1021.0 64-bit (September 2022).
You can try to update the Desktop Version to try it .
What's new in the latest Power BI update - Power BI | Microsoft Learn
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi, @Saran_T22
In Power Query Editor,We use M language to connect the data source.M language is case-sensitive, your error message uses "Databricks.query", you can try to change to the corresponding "Databricks.Query".
For more information , you can refer to this document:
Connect to Power BI - Azure Databricks | Microsoft Learn
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Thanks, I tried that as well but same error 'Expression.Error: The name 'Databricks.Query' wasn't recognized. Make sure it's spelled correctly.'
Hi , @Saran_T22
I test in my Power Bi Desktop , the spell of the function is right. You can enter the function like the screenshot like this:
You can read the function document how to use this function.
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Strange. When I search for the function with databricks, these are the only options I see. Is it because of my version or something???
Hi , @Saran_T22
My Desktop Version: 2.109.1021.0 64-bit (September 2022).
You can try to update the Desktop Version to try it .
What's new in the latest Power BI update - Power BI | Microsoft Learn
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
142 | |
71 | |
64 | |
52 | |
50 |
User | Count |
---|---|
208 | |
91 | |
62 | |
59 | |
56 |