Query Folding in Power BI
2022TL; DR
Using (Power) Query Folding to your advantage
Session Details
Are you working with Power Query, in Excel or Power BI? Have you ever experienced that the importing of data is slower than you expected? In most of those cases, query folding is probably not happening fully optimized.
Query folding is important because it offloads data transformations to the source, instead of performing them in Power Query.
Attend this session to learn how to ensure that you get all the performance improvements possible in your reports.
You will learn how to check if a query (really) folds, how to use the Query Diagnostics feature, how to make a native SQL query fold, and how (not) folding can hurt your performance.
3 things you'll get out of this session
Speakers
Nicky van Vroenhoven's other proposed sessions for 2026
A Deep Dive Into The Power BI Direct Lake - 2026
From Report to Action: Write-back with Translytical Task Flows - 2026
How to use GraphQL with Fabric SQL Database to Expose Data Externally - 2026
Optimizing Your Power BI Workflow with Project Files, Source Control, and TMDL - 2026
What are Power BI External Tools and How Can I Use Them? - 2026
Nicky van Vroenhoven's previous sessions
A Form, a Flow and a Power BI Streaming Dataset Walk Into a Bar
Learn how to integrate Microsoft Forms, Power Automate and Power BI into a live interactive data application!
Write-back with Power Apps in Power BI
Do you want to let the business easily add targets, comments and/or change data quality issues in your Power BI reports? Then you should incorporate write-back with Power Apps to your Power BI reports.
Power Platform Better Together: Create a Scoring App with a Live Dashboard
Use the Power Platform to create an interactive scoreboard