Forum Discussion
How to improve the report performance
I have a report where i am using around 50 measures everything needs to be calculated in runtime based on the date value i select. The report takes lot of time to refresh whenever i change the date f...
- Remove unwanted columns in the data model.
- Avoid nested functions,e.g. IF, CALCULATE, etc. used in calculations.
- Too many visuals on a page will render poor performance even is using
bookmarks. Data granularity reduction by aggregating to a level higher like reporting in months instead of days.Replace caculated columns with measures.