Video unavailable
SQLBits 2022
Query Folding in Power BI
Using (Power) Query Folding to your advantage
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.