Forum Discussion
Dashboards with Slow Performance
Most of the data is coming from a live connection to a SQL Server Analysis Services database. We do have reports that are bringing in data from Import Mode on SQL queries from our database. No gateways invovled.
All of the reports that are populating information on dashboards are working properly. Data has been getting refreshed, functionality still there (drill through, use slicers/filters), and ultimately no new updates have been made to our reports. The issue is once a report is pinned to a dashboard, the performance and load time of the tile drops. It becomes very slow to load and sometimes is not loading slicers/visuals.
Once clicking through the tile onto the report the dashboard is built off, the report works as expected. It is only when viewed as a dashboard does it take longer to load.