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
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