What kind of data source are you connecting to, is it an extract?
How many filters do you have? Are they cascading (relevant values only) filters?
Is this the same issue when you open up the workbook in desktop? It might be worth opening it in desktop and going to help-> Settings and Performance -> Start Performance recording:
Thanks for quick response.
We are connecting to SQL Server database which is a Live connection. We have 5 dashboards(In each dashboard we have min of 4 sheets and maximum of 20 sheets), but we are not displaying all at once. Based on the parameters we are displaying maximum 5 sheets in each dashboard.
We have around 6 filters.
In desktop it is working fine.
In Desktop it might be fine because of caching, when someone accesses this view via web then it'll have to cache and it'll take longer.
I see the live SQL database connection as one of the key reasons why it might be slower too. Have you tried making an extract and see if this will improve performance?
Because your dashboards have up to 20 sheets then this will have a major impact on performance. Although your parameters are hiding these views, it'll still cause a lag because the parameters work with the filters to 'hide' certain worksheets. So the worksheets are still active on the dashboards, but they're just hidden away.
If possible, some tips on improving performance based on what you've told me:
- Instead of a live connection, use an extract and use a incremental refresh or daily refresh
- Reduce the number of worksheets in one view
- Reduce the number of filters and avoid using relevant filters to improve performance
We need to have live connection because data will change frequently in a day. Do we have any cache concepts that we can implement Java Script API?