Micro Free Course — 100% Free Learning
All lessons in this module are free to learn. Sign in with Google to save your progress.
0
Ingestion Architecture, Power Query & Storage Modes
Master data connectivity, VertiPaq in-memory columnar compression, DirectQuery pushdown, Composite models, Roche's maxim, and Query Folding diagnostics.
Module Progress0% Complete
65 min total
4 Lessons
0 Completed
Module Content
Data Connectivity & Storage Modes: Import vs DirectQuery vs Dual
Understanding VertiPaq columnar memory compression vs live SQL query pushdown; Composite models and Dual storage mode.
8 minVideo
Start
The Ingestion Engine: Power Query M, Query Folding & Source Pushdown
In-depth didactic guide on M execution containers, VertiPaq 3-stage compression, Roche's maxim, and Query Folding mechanics.
25 minArticle
Start
Diagnosing & Fixing Broken Query Folding in Power Query
How to isolate non-folding M steps, inspect Query Plans, and enable query folding on custom native SQL queries.
8 minVideo
Start
Quiz: Storage Modes, Ingestion & Query Folding
10 scenario-based psychometric questions testing storage mode trade-offs, Query Folding, and Power Query architecture.
20 minAssignment
Start