Forum Discussion
Performance isseue
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
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