Forum Discussion
can use custom sql query in power bi with AZURE databricks
4 Replies
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.
Thanks Stephen
in future version of powerbi with azure databricks can support custom sql query?
Have you tried this manual:
https://learn.microsoft.com/en-us/azure/databricks/integrations/bi/power-bi#using-a-custom-sql-query?
