Dashboards with Slow Performance

[jcagg3010]

Currently experiencing dashboards that are slow to load upon initial open for several users. These dashboards opened normally and loaded quickly for several months prior to today. No updates were made to these dashboards. Some visuals do not appear once the dashboard is finally loaded - especially any Slicer visuals.

The reports for these Dashboards are loading properly and quickly. Just when any report is being pinned to a dashboard, there is very slow rendering time. Nothing is wrong on our data end.

[Anonymous]

What is your environment like ( Premium or PowerbI service)?  If you are using premium , did you see any spikes in CPU or memory utlization?

https://learn.microsoft.com/en-us/power-bi/enterprise/service-premium-metrics-app

Can you also describe your workoads ? Example : How many reports and datasets you have in each environment (EXAMPLE: DEV,TEST,PROD)?

[jcagg3010]

We have a Power BI service environment and I do not have access to see any spikes in CPU or memory utilization. Have about 20 reports in Dev, 5 in Test, and 60 in Prod.

Have about 10 workspaces, with dashboards in several workspaces that all experience the same issue. 

[jcagg3010]

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.

[edhans]

Import mode, Direct Query to on prem or cloud RDBs, DQ to AAS/PBI Datasets? Gateway's involved? 

Need a lot more info before we can begin to suggest where to look.

How to get good help fast. Help us help you.

How To Ask A Technical Question If you Really Want An Answer

How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.