Power Query is a powerful extract, transform, and load tool. This presentation will show you how you can improve your queries by getting a relational database server, like SQL Server, to do a lot of the processing for you by maximizing a feature call Query Folding. We will also discuss some more advanced concepts like working with nested tables, and also work directly with some M Code. We'll walk through a few examples to show you how versatile Power Query can be and how you can leverage its capabilities for your reports.
