Forum Discussion

Saran_T22's avatar
Saran_T22
Regular Visitor
3 years ago
Solved

Custom SQL in power Bi Desktop

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 tri...
Need Help
v-yueyunzh-msft's avatar
v-yueyunzh-msft
Community Support
3 years ago

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

 

Saran_T22's avatar
Saran_T22
Regular Visitor
3 years ago

Thanks, I tried that as well but same error 'Expression.Error: The name 'Databricks.Query' wasn't recognized. Make sure it's spelled correctly.'

  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    Community Support
    3 years ago

    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

    • Saran_T22's avatar
      Saran_T22
      Regular Visitor
      3 years ago

      Strange. When I search for the function with databricks, these are the only options I see. Is it because of my version or something???