22-25 April 2026

Optimising Power BI Performance Through Data Modeling

Proposed session for SQLBits 2026

TL; 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.

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