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
▶︎
Power Query - Exact Match Lookups (1 Goal; 3 Methods)
▶︎
Power Query - Avoid "Helper Queries" (+10 Cool Tricks)
▶︎
Power Query - Creating a Flat File (plus, 14 Pivot Table Styling Tips)
▶︎
SQL Activity & Data Views in Salesforce Marketing Cloud | Query Customer Data Like a Pro
▶︎
Power Query - Dynamic Column Selection
▶︎
How to remove sorted duplicates in Power Query the right way
▶︎
Stop Using Power Query with Default Settings (Change These 7 First)
▶︎
Power Query - Unlimited Formulas in 1 Step
▶︎
Microsoft Excel - Logical Function (AND, OR, NAND, NOR, XOR, and XNOR)
▶︎
Avoid Power Query Failures: The Smart Way to Manage Column Names
▶︎
These 5 Custom Column Tricks Make Power Query Easier
▶︎
Power Query - Data from Email Attachment
▶︎
Power Query - 3 Ways to Correct Unexpected Results when Removing Duplicates
▶︎
Power Query was HARD until I learned these 7 Tips
▶︎
Power Query Secrets - Simple tweaks is all it takes.
▶︎
Microsoft Excel - 6 Amazing Uses of Conditional Formatting (Tricks you've 'likely' never seen)
▶︎
How to use Microsoft Power Query
▶︎
Why I Stopped Relying on Power Query UI
▶︎
How to Keep Manual Changes with Power Query... It's Easy When You Know How!
▶︎