SQLBits 2014

Power Query: Beyond The Basics

An in-depth session on advanced Power Query functionality and the M language

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.