From Prototype to Production: Turn Power Query into Scalable Data Pipelines with AI
About the Session
Power Query is your secret weapon for rapid prototyping—and now it can become the bridge between analytics and engineering teams.
Leverage the business logic you've already perfected in Power Query as a shared design language, then seamlessly convert proven prototypes into production-grade Fabric pipelines that scale to enterprise data volumes.
What you'll learn:
- Apply Power Query as a rapid prototyping tool that validates transformation logic and communicates requirements to data engineering teams in a language both sides understand
- Implement Medallion Architecture (Bronze, Silver, Gold) to structure scalable, maintainable data pipelines that serve both BI and engineering needs
- Convert Power Query prototypes to Fabric Notebooks preserving business logic while gaining enterprise performance and orchestration
- Design effective handoff documentation** that translates Power Query transformation steps into clear data engineering requirements with testable acceptance criteria
- Leverage AI coding agents and skills to auto-generate Fabric Notebooks from Power Query prototypes, validate transformations, and accelerate the transition from prototype to production code
Prototype fast in Power Query, align your teams around a shared specification, and deploy production pipelines that scale to billions of rows—turning your existing BI expertise into a data engineering superpower.
Mihály Kávási
Fasttrack Recognized Solution Architect,
One Day Business Intelligence
About the Speaker
Mihaly discovered Power BI 8 years ago and has since become an expert on Power Platform.
His deep understanding of business processes and decision drivers makes him a valuable adviser for customers looking to derive the most value from their assets.
Mihaly helps customers define optimal governance structure and implement the right mix of governed self-service BI, as well as advises them on security and performance optimization and managing large scale deployments.
He nurtures the next generation of analysts with an emphasis on user needs and UX.
Certified Trainer since 2018, Fast Track Recognized Solution Architect for Power BI since 2021.