You already know that you can accomplish a lot within the Power Query user interface. If you are a data steward, however, you may be asked to deliver complex data sets in Power Query that require knowledge of advanced functionality, including the M language. This session will examine what these requirements might be, how to implement them, and how best to deploy them to end users. 

In this session you will learn how to create common types of calculations and transforms in M, how to best use functions, how to work with multiple data sources, how to call web services, what the best practices for loading data into Power Pivot with Power Query are, and lots more. 

Slide deck 238 KB , MP4 Video HD 557 MB