~/talk

Get a Load of this - Realistic Load Testing for Power BI, explained!

Talkat SQLBits 2024 · 2024-03-19..03-23· [devops-and-delivery]
links:none on file
slides:none on file

Shows a concrete workflow using the open-source Realistic Load Test tool (forked PowerShell scripts) to spin up multiple browser windows, simulate bookmarks and slicers, and record per-refresh timings into Excel and a Power BI report. Requires admin PowerShell and an AAD token (60 min), advises not to exceed physical CPU cores; demo runs four concurrent users and reports a 3.65s average, while a real incident generated >2,000 requests and stalled capacity. Also demos spinning an F2 fabric capacity up and pausing it.

AI-written summary · about

  1. 0:00Realistic load testing intro
  2. 1:14What load testing is
  3. 3:44Load vs stress testing
  4. 5:26Load testing before production
  5. 8:36Preparing for load testing
  6. 10:43Realistic Load Test tool
  7. 12:49First automated load test demo
  8. 14:32Testing a Power BI report
  9. 22:24Bookmarks and filters for scenarios
  10. 26:06Azure Fabric capacity testing
  11. 31:59Advanced use cases
  12. 36:13Future improvements
  13. 37:17Summary
~/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.