~/talk

Troubleshooting Power BI Reports

Talkat SQLBits 2023 · 2023-03-14..03-18· [data-visualization, web-performance]
slides:none on file

Shows concrete fixes: using the Performance Analyzer Pane and optimize ribbon to find slow visuals, replacing dozens of shapes with a single background and consolidating 17 cards into one table cuts render time from ~55–60s to ~4–5s; disabling auto date/time drops a model from ~8.5 GB to ~600 MB; converting a flat 31 GB CSV into a star schema shrinks it to ~840 MB; a single calculated column can add ~20 minutes to refresh. Tools shown: Power BI Desktop, DAX Studio, Tabular Editor.

AI-written summary · about

  1. 0:00Introduction and context
  2. 2:20Performance fundamentals
  3. 5:44Report diagnostic journey
  4. 9:21Using performance analyzer
  5. 12:38Visual and UI optimization
  6. 20:29Table and filter efficiency
  7. 24:36Mapping and quick wins
  8. 26:41Data transformation best practices
  9. 30:12Data types and model size
  10. 35:34Star schema architecture
  11. 41:59Advanced considerations
  12. 45:14Wrap up and Q&A
~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.