Optimising Power BI Performance Through Data Modeling
Proposed session for SQLBits 2026TL; DR
Learn how a well-designed data model can significantly improve Power BI performance and simplify DAX. This session explains the key modeling principles that help you build faster, more efficient, and easier-to-maintain reports.
Session Details
Do you want to improve the performance of your Power BI dashboards? In practice, most performance issues can be solved with a small number of targeted improvements to the data model.
In this session, we focus on the fundamentals of data modeling and their impact on performance. The following questions are addressed:
What defines a solid foundation for a Power BI data model?
What are the strengths and trade-offs of different modeling approaches?
How can data be shaped to support correct and meaningful insights?
A well-designed data model often resolves multiple challenges at once. It can significantly improve report performance with relatively small adjustments and make DAX measures easier to write, understand, and maintain.
By the end of the session, you’ll have a clear framework for evaluating and improving your own data models and can apply these principles directly in your daily work.
In this session, we focus on the fundamentals of data modeling and their impact on performance. The following questions are addressed:
What defines a solid foundation for a Power BI data model?
What are the strengths and trade-offs of different modeling approaches?
How can data be shaped to support correct and meaningful insights?
A well-designed data model often resolves multiple challenges at once. It can significantly improve report performance with relatively small adjustments and make DAX measures easier to write, understand, and maintain.
By the end of the session, you’ll have a clear framework for evaluating and improving your own data models and can apply these principles directly in your daily work.
3 things you'll get out of this session
Understand the key data modeling principles that impact Power BI performance
Evaluate the strengths and trade-offs of different data modeling approaches
Apply practical modeling improvements to simplify DAX and speed up reports
Speakers
Peter van den Bos's other proposed sessions for 2026
Incremental Refresh Power BI - 2026
Modeling Power BI with Code: Unlocking the Power of Semantic Link - 2026
Practical Data Modeling in Power BI: Beyond the Star Schema - 2026
Unlocking the Power of the VertiPaq Engine: Data Modeling for Maximum Performance - 2026