Power Query - Query Folding (The key to faster query execution)

Understanding Query Folding: the process by which transformation steps are performed at the data source to improve query execution time. Examine strategies to repair "broken" queries, and techniques to turn partial-folded queries into fully-folded queries.
00:02 What is Query Folding?
00:46 Query Evaluation Process
01:43 Query Folding Levels
02:28 What makes Query Folding break?
03:17 Folding Indicators Explained
03:57 Example of a Hybrid Query
06:36 Breaking the Folding Chain
07:59 Fixing "Broken Chains"
08:42 Automatic Query Optimization
09:00 Viewing Step Folding in Excel / Power BI
11:40 Query Optimization