Forum Discussion
Performance isseue
Can someone helpme in the issue facing where my report visuals are loading very slow, pages take too much time to open, and the visuals keep rending for long, especially because the dataset is big and I have more than 50 measure. Some of the DAX formulas are also using table filters instead of column filters in calculate /
Use Performance Analyzer (View > Performance analyzer) to identify slow DAX queries and visuals, then simplify by removing unnecessary columns or using aggregations in Power Query.
Optimize DAX: Replace table filters with column filters in CALCULATE, avoid bidirectional relationships unless needed, and use tools like DAX Studio for query profiling.
Reduce model size by vertical filtering (drop unused columns), implementing incremental refresh for large tables, or switching large fact tables to DirectQuery if supported.
Usually the problem comes from
- a lot of visuals in a single page
- bad DAX code
- bad data model
Given this, to help you more, we need the pbix, can you share it?
If this helped, please consider giving kudos and mark as a solution
me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
2 Replies
Use Performance Analyzer (View > Performance analyzer) to identify slow DAX queries and visuals, then simplify by removing unnecessary columns or using aggregations in Power Query.
Optimize DAX: Replace table filters with column filters in CALCULATE, avoid bidirectional relationships unless needed, and use tools like DAX Studio for query profiling.
Reduce model size by vertical filtering (drop unused columns), implementing incremental refresh for large tables, or switching large fact tables to DirectQuery if supported.
Usually the problem comes from
- a lot of visuals in a single page
- bad DAX code
- bad data model
Given this, to help you more, we need the pbix, can you share it?
If this helped, please consider giving kudos and mark as a solution
me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI