22-25 April 2026

Power BI on a diet: 5 TIPS to slim down your semantic models

Regular 50 minute session for SQLBits 2026

TL; DR

Learn 5 practical techniques to reduce Power BI model size and boost performance. Discover how to spot bloat, cut memory usage, improve DAX speed, and use VertiPaq Analyzer and cardinality insights through real demos.

Session Details

Is your Power BI report starting to feel like it’s dragging its feet? In this fast-paced and practical session, we’ll explore five simple yet powerful techniques to slim down your semantic model and dramatically boost performance. Learn how to identify bloated areas, reduce memory consumption, and optimize execution times with ease.

You’ll get a hands-on look at how tools like VertiPaq Analyzer can help you understand and inspect model size, plus live demos that reveal the real-world impact of each tip. Whether you’re a report author or a data modeler, these strategies will help you deliver faster, leaner, and more efficient Power BI experiences.

Key Takeaways:
✅ How data reduction directly improves DAX execution
✅ Introduction to VertiPaq Analyzer for model diagnostics
✅ Introduction to cardinality
✅ Live demonstrations of each optimization in action

3 things you'll get out of this session

Understand why model size directly impacts Power BI performance
Identify and remove unnecessary data to reduce memory usage
Use VertiPaq Analyzer to diagnose model bloat
Grasp cardinality and its effect on compression and speed
Apply practical optimizations that improve DAX execution immediately