Best practices for developing Power BI reports
summary
Seven practical Power Query rules: query folding whenever possible, load only needed columns/rows, set explicit data types, name queries and transformation steps with why comments, compress steps and use remove other columns not remove. Disable Auto date/time — one model with 167 date columns created 90 MB of hidden calendars. Use star schema, avoid many‑to‑many and bidirectional filters, prefer measures in a dedicated measure table, and limit visuals (example: a report with 1,100 visuals and a page of 267 visuals takes ~1 minute to load).
AI-written summary · about
chapters (5)
- 0:00Introduction to best practices
- 2:57Why best practices matter
- 7:27Power query optimization
- 27:47Data modeling and DAX
- 38:40Visualization best practices
related talks
01h 04mBest Practices for Collecting and Analyzing Data with Power Query and Excel
02h 12mOptimizing your Power Pivot models using Power Query
51mPower BI Composite and Hybrid Models
01h 04mThe Art of Prototyping Analytics
48mCombine Power BI with External Tools
54mMy Brain Hurts: Presenting Data with Microsoft Tools
14mPower Query Tips to Automate Your Tasks
48mDon't be scared with Hybrid, they are only tables…