Slow initial load

Hi  gustavjMC  , 

To optimize report loading, you can try the following operations:

1. Check the refresh summary and the metric usage app to view the refresh time, allocate reasonably, and try to choose the idle time to refresh. The refresh time with centralized refresh time is divided equally, so as to avoid too many people occupying resources and causing queuing

2. Select the correct capacity. For those datasets whose data refresh time reaches 2 hours, place them in the premium capacity, and the maximum refresh time is 5 hours

3. Remember the refresh limit. When the source data source is frequently refreshed, choose the DQ / LC mode as much as possible, because the import mode will constantly refresh the data set of the import mode and occupy resources. However, DQ / LC will limit the number of rows of returned data to 100W, and the corresponding time limit for running query is 225 seconds, which is more effective for refreshing

4. Optimize the tables and columns used by datasets and reports or instruments, avoid using complex DAX functions and delete useless fields

5. Limit the number of visual objects on the dashboard rather than using RLS

6. Use a reliable on premises data gateway to prevent the report from being unavailable or overloaded and failing to refresh the report. It also ensures that the physical machine configured with the gateway is not far away from the physical machine using the gateway, so as to avoid the geographical location from affecting the speed

7. Go to capacity setting and select a capacity node. Look at the workload settings. Adjust the resource allocation of the dataset to a small extent and the resource allocation of the dataset to a higher level

This is the related content and video about the problem, hope to help you:

https://docs.microsoft.com/en-us/power-bi/guidance/power-bi-optimization

https://docs.microsoft.com/en-us/power-bi/guidance/report-performance-troubleshoot

https://www.youtube.com/watch?v=vbS7WuH6PO8

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.