The Path to Success with Power BI: Best Practices
summary
Demonstrates concrete Power BI fixes: use Power Query Online indicators and query folding to push filters back to SQL, inspect the view query plan to find buffering vs remote steps, and copy dataflow M into Desktop; shows enabling folding for hand‑written SQL with enableFolding=true in Value.NativeQuery. Benchmarks a flat 500M‑row view that refreshes 34 minutes versus a star schema at 4 minutes. Uses DAX Studio and a VPAX to find bloat (469 MB → 3 MB by removing auto date tables) and Performance Analyzer to cut pages with 60 visuals to sub‑second.
AI-written summary · about
chapters (6)
- 0:00Introduction and overview
- 1:03Understanding query folding
- 16:58Star schema best practices
- 24:02Optimizing models with VPAX
- 35:16Report performance tips
- 45:29Q&A and closing
related talks
51mTroubleshooting Power BI Report Performance
46mVisualizing Data for Non-Data Experts: Making Reports Accessible to All
50mLessons learned: Governance and Adoption for Power BI
01h 08mAdvanced Modelling and Calculation Using the Power BI Designer
50mBuilding an Empire - Implementing Power BI Step by Step
54mData Visualization with Power View and the Tabular Model
18mEmpowering Business Through Data
01h 04mThe Art of Prototyping Analytics