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?
This…
Continue Reading Joel Lindstrom, Shawn Tabor, George Doubinski, Matthew C Anderson, Mark Smith, Scott Sewell’s Article on their blog
CRM Audio: Power BI 24: SQL or PowerQuery?
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.
Blog Syndicated with Joel Lindstrom, Shawn Tabor, George Doubinski, Matthew C Anderson, Mark Smith, Scott Sewell’s Permission
More About This Author
Array
Podcasts24 August 2023Payments in Power Pages or Show Me The Money
Podcasts27 June 2023The Hunt for Script October or Where TF Did You Put That Script
Podcasts18 April 2023Life As a Template
Podcasts21 February 2023Release Tsunami 2023