Power BI 24: SQL or PowerQuery?

Posted By CRMAudio on 25 Oct 2017 in Podcasts

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

CRMAudio

Array

Array

• Podcasts17 May 2024Wave 1 2024: Deprecation is not a reason for depression
• Podcasts16 November 2023Back to School or What's New Wave 2 2023
• 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