SQLBits 2024

Power Query in 20 Minutes - How it Works

Power Query is showing up in more and more technologies, such as Power BI and Fabric. It's easy to get started but not easy to understand. In this session we'll go through some of the internals so you have a better grasp of the tool.
Power Query is showing up in more and more technologies, such as Power BI and Fabric. While it's is easy to work with and get started, but that doesn't mean it's clear what it's doing.

In this session, we'll cover how the Power Query engine works, how M works, and how to take advantage of Query Folding.

By the end of this session, I'll have a better understanding of what's happen when you use Power Query and won't be dependent on the GUI.