Performance isseue

[Yuziu8o]

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 /

[Shubham_rai955 · Accepted solution]

• 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.

[FBergamaschi · Accepted solution]

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

[Shubham_rai955 · Accepted solution]

• 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.