Forum Discussion

Matthias93's avatar
Matthias93
Icon for Helper III rankHelper III
9 years ago

Report is too slow

Hi, I currently have a dashboard based on 5 excels and 10 SharePoint lists. To increase the speed of this report I have done mulitple things:    Deleted columns I don't need (will it make a diffe...
Need Help
Matthias93's avatar
Matthias93
Icon for Helper III rankHelper III
9 years ago

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

Ermin's avatar
Ermin
Icon for Advocate II rankAdvocate II
9 years ago

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