Power Query in 20 Minutes - How it Works
summary
Power Query appears as a clicky UI but actually generates M code, follows an 80/20 practical rule and behaves lazily: it drops or reorders steps it deems unnecessary and pushes work back to the source via query folding (inspectable with View Native Query). Examples: filter and computed column work can fold into ugly machine SQL; memory and compute are limited (hundreds of MB per container), buffering forces execution, and you can hard‑code SQL when needed.
AI-written summary · about
chapters (8)
- 0:00Introduction to Power Query
- 1:02Understanding Power Query
- 3:16The toolkit is a junk drawer
- 6:45It is not no-code
- 8:03Linearity vs lazy evaluation
- 10:15Query folding and performance
- 13:26Recap of the three truths
- 15:58Q&A and practical demo
related talks
01h 13mDiscover, Acquire, and Transform Your Data with Power Query
02h 12mOptimizing your Power Pivot models using Power Query
01h 04mBest Practices for Collecting and Analyzing Data with Power Query and Excel
51mPower BI Composite and Hybrid Models
18mEmpowering Business Through Data
54mData Visualization with Power View and the Tabular Model
01h 03mBudgeting with Power Pivot
48mGo With The (data)Flow