This session presents a practical walk-through of a real-world Power BI solution designed to support 20,000 users at Microsoft.

It explores how a notebook-driven method can streamline load testing—from capturing DAX queries and configuring row-level security (RLS), to stress-testing capacity under high concurrency, and finally analyzing test results.

Attendees will discover how these steps help establish benchmarks, optimize Power BI reports, and more accurately gauge capacity requirements, all within an easy-to-configure end-to-end process.