Custom SQL in power Bi Desktop

[Saran_T22]

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. 

[v-yueyunzh-msft]

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]

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]

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]

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

[v-yueyunzh-msft · Accepted 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