Skip to content

Power Query Unchained: The Power of M

We’re excited to reveal the second training day for Power BI Next Step 2026, and it’s a special one for anyone who wants to move beyond the Power Query interface and truly understand what’s happening under the hood.

Rick de Groot will deliver a full-day training titled “Power Query Unchained: The Power of M.”

Many Power BI developers rely heavily on the Power Query UI. It’s powerful, but it can also lead to queries filled with hardcoded steps that break when data changes or require constant manual adjustments. This training is all about stepping beyond those limitations by understanding and using the M language directly.

During the day, Rick will guide attendees through the core concepts that make M such a powerful tool. You’ll learn how structured values like lists, records, and tables work, and how understanding them unlocks a completely different way of thinking about data transformations. The focus is on writing dynamic, flexible, and maintainable queries that adapt naturally as your data evolves.

The session also explores how a deeper understanding of M allows you to extend the capabilities of familiar functions, shape your data more effectively, and build smarter input logic without relying on hardcoded values. Along the way, Rick will also show practical techniques for structuring and organizing query logic, making even complex transformations easier to manage.

Whether you’re just starting to explore M or already using it occasionally, the goal of this training is to give you a new perspective on what’s possible with Power Query.

And who better to teach it than Rick de Groot.

Rick is one of the most respected voices in the Power Query community. He is the author of The Definitive Guide to Power Query M and runs the blogs Gorilla.bi and PowerQuery.how, where he turns complex concepts into practical lessons that data professionals can apply immediately.

If you’ve ever felt that Power Query is powerful but somehow still limiting, this training will show you how to break free from those constraints and unlock the full power of M.

More details about training day tickets and availability will follow soon.