No-Code, Low-Code, Pro-Code: Unlocking Data Magic with Fabric Dataflows Gen2
Proposed session for SQLBits 2026TL; DR
Discover how Dataflows Gen2 empowers every skill level: no-code, low-code, and pro-code.
See the same scenario built three ways and learn practical strategies to streamline data prep, automate workflows, and scale governed data reuse in Fabric
Session Details
In today’s data-driven world, different users need different tools, but they all share the same goal: getting trusted, clean, and useful data quickly. Whether you're a business analyst, citizen developer, or data engineer, Microsoft Fabric’s Dataflows Gen2 meets you where you are, offering a flexible spectrum of options: no-code, low-code, and pro-code.
In this session you'll learn how to build and manage Dataflows Gen2 using simple, no-code steps. Then, we’ll explore low-code techniques like Power Query transformations and parameterization to unlock more advanced capabilities. Finally, we’ll step into the pro-code space with custom M code and performance best practices for those needing full control.
You’ll see a real-world scenario built in three ways: no-code, low-code and pro-code, so you can compare the trade-offs, strengths and ideal use cases for each.
Whether you're looking to simplify data prep, enhance automation, or enable governed data reuse at scale, you’ll leave with practical strategies and inspiration for making the most of Dataflows Gen2 in your projects.
In this session you'll learn how to build and manage Dataflows Gen2 using simple, no-code steps. Then, we’ll explore low-code techniques like Power Query transformations and parameterization to unlock more advanced capabilities. Finally, we’ll step into the pro-code space with custom M code and performance best practices for those needing full control.
You’ll see a real-world scenario built in three ways: no-code, low-code and pro-code, so you can compare the trade-offs, strengths and ideal use cases for each.
Whether you're looking to simplify data prep, enhance automation, or enable governed data reuse at scale, you’ll leave with practical strategies and inspiration for making the most of Dataflows Gen2 in your projects.
3 things you'll get out of this session
Clear understanding of when to use no-code, low-code, or pro-code approaches in Dataflows Gen2.
Hands-on techniques to improve data preparation, automation, and performance in Fabric.
Practical guidance for scaling governed, reusable data solutions across different user roles.