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 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. 

Need Help

5 Replies

  • 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