Query folding is a process in Power Query where the query engine tries to convert the user's query steps into a single optimized SQL statement that can be sent to the data source.

If the query engine can perform query folding successfully, it can reduce the amount of data that needs to be transferred over the network and improve the performance of the query.

It's worth noting that not all query steps can be folded, and some data sources may not support query folding at all. However, by understanding query folding and designing queries with query folding in mind, you can improve the performance and accuracy of your Power Query queries.

This session will demonstrate the key principles to enable query folding to happen and those that can reduce folding.

(50 mins)