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