can use custom sql query in power bi with AZURE databricks

[pankajtech__76]

[Anonymous]

Hi @pankajtech__76 ,

Sorry, we can't use sql statement to query in Power Query. Actually, the M language is uesd in Power Query. Any transformation you apply will be written in M language. Please refer to

Basics of M: Power Query Formula Language - RADACAD

Quick tour - PowerQuery M | Microsoft Learn

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[pankajtech__76]

Thanks Stephen 

in future version of powerbi with azure databricks can support custom sql query?

[Stachu]

Have you tried this manual:
https://learn.microsoft.com/en-us/azure/databricks/integrations/bi/power-bi#using-a-custom-sql-query

?

[pankajtech__76]

Yes,I have tried but facing same issue