Many of us have heard that we should be performing as many transformations upstream when using Power Query. While this is a noble cause, it is not always practical. For many, Power Query is a tool that can help extract data from different sources that might not be within our control. The result requires you to leverage Power Query for your transformations. But with a few adjustments, you could end up getting the most out of the tool.

In this session, we will explore some of the hidden secrets of Power Query that can transform how you manage data in Power BI. We will explore how to manipulate data connections, aggregate data, merge/append queries, create dimensions, invoke custom functions, and manage queries with parameters. We will even dive into how to modify some of our transformations within the advanced editor by writing a few lines of code. We will also explore some best practices to help optimize our queries.

At the end of this sessions, attendees will understand some of the techniques to help expand their utilization of Power Query as they go to create their own solutions in Power BI.