Query Folding in Power BI
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, and even how to make a Native SQL query fold!
You will also see how (not) folding can hurt performance.
This is an intermediate, one hour technical session. A basic understanding of Power BI Desktop is required because it goes under the cover into Power Query.
Nicky van Vroenhoven
Unit Lead Power BI
's-Hertogenbosch, The NetherlandsView Speaker Profile