Forum Discussion
Report is too slow
Hi,
I tried this and it seems to be working nicely. I have the impression performance has improved, but it can still be quite slow. This could indeed be due to the slicers I have on each page.
Thanks for helping me out!
Kind regards,
Matt
Hi @ Matthias93,
As said I have an impression that the number of slicers and dependency between the slicers and the charts play a significant role in the report performance. I have performance issues on one of my report although I don’t have any measures or significant calculations and the number of data is way lower than what I usually have. The only difference to my other reports is number of slicers.
Try duplicating your report to another tab then remove few slicers and test performance again. I’m sure that the performance will improve. This will just help you answer the question, Is it the number of slicers or the calculation intensive measure causing the performance issues.
If it is number of slicers, then we both have another issue which I have no clue how to resolve J. Maybe a new post or bug report to Microsoft will help.
Regards,
Ermin
Removing all slicers but one did indeed make the report faster, but still not fast enough in my opinion, especially when considering how small my dataset is at the moment. The slicers always cross-filter when you make a selection, this indeed eats up a lot of the performance.
Kind regards,
Matt