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?

Power BI 24: SQL or PowerQuery?

CRM Audio is a network of podcasts about Dynamics 365, Dynamics CRM, personal productivity, and Power BI hosted by Microsoft Business Solutions MVP's Joel Lindstrom, George Doubinski, Shawn Tabor, Mark Smith, and Scott Sewell and productivity expert Matthew C. Anderson. We are the original CRM MVP Podcast.  Podcasts in the feed:

CRM Audio - a roundtable discussion of all things CRM, including what's new, best practices, and answers to your CRM questions and Power BI.

Power BI and More - Microsoft Business Solutions MVP Scott Sewell teaches you how to learn Power BI and effectively use it with Dynamics 365.

Prodcast - All about personal productivity. We get deep into productivity and cut through the hype around productivity tools, and tell you what's not productive.

Technology

CRM Audio is a network of podcasts about Dynamics 365, Dynamics CRM, personal productivity, and Power BI hosted by Microsoft Business Solutions MVP's Joel Lindstrom, George Doubinski, Shawn Tabor, Mark Smith, and Scott Sewell and productivity expert Matthew C. Anderson. We are the original CRM MVP Podcast. Podcasts in the feed: CRM Audio - a roundtable discussion of all things CRM, including what's new, best practices, and answers to your CRM questions and Power BI. Power BI and More - Microsoft Business Solutions MVP Scott Sewell teaches you how to learn Power BI and effectively use it with Dynamics 365. Prodcast - All about personal productivity. We get deep into productivity and cut through the hype around productivity tools, and tell you what's not productive.

Share Power BI 24: SQL or PowerQuery?

Sign up to save your podcasts

Power BI 24: SQL or PowerQuery?

Power BI 24: SQL or PowerQuery?