Performance tuning Dataflows Gen2

Proposed session for SQLBits 2026

TL; DR

Learn how new features in Dataflows Gen2 result in better performance and lower CU cost

Session Details

For anyone doing self-service data transformation in Fabric, recent enhancements to Dataflows Gen2 mean they are now significantly quicker and cheaper than Dataflows Gen1. In this session you will learn how to make your Dataflows Gen2 run faster and use fewer CUs by tuning your M code and taking advantage of new features such as fast copy, partitioned compute and the modern query evaluator.

3 things you'll get out of this session

* Learn about recently released features in Dataflows Gen2 * Tune Dataflows Gen2 so they run faster * Tune Dataflows Gen2 so they consume fewer CUs

Chris Webb's other proposed sessions for 2026

Fabric Power Hour - 2026

Tuning Power BI Copilot with AI Instructions - 2026

Secrets of Power BI Performance Analyzer - 2026

Chris Webb's previous sessions

What's new in Power Query in Power BI, Fabric and Excel?

Find out about new Power Query features in Power BI Desktop, Fabric Dataflows and Excel.

Connect Excel to Power BI data with Live Connected Tables

In this session you'll learn how to create Live Connected Tables and what the advantages and disadvantages of using them are.

Fabric Power Hour

The famous Power BI Power Hour returns, but this time it has expanded to cover the whole of Fabric!

Fabric Direct Lake Deep Dive

Learn how the new Direct Lake mode for Power BI in Microsoft Fabric works