The Dynamics 365 Podcast

Power BI 24: SQL or Power Query?

In this episode (sponsored by Kingswaysoft), Scott Sewell and Joel Lindstrom discuss whether you should use PowerQuery/M for complex Power BI queries, or if you should aggregate via SQL server and make Power BI the visualization layer. Also discussed: is Power Query sufficient for most queries, or should you learn the underlying M language. And what is the difference between M and Dax?