"Loading data..." message when opening a report based on processed/refreshed(!) import dataset

Hi  Markoff ,

"Dataset eviction": Power BI uses dynamic memory management to evict inactive datasets from memory. 

https://docs.microsoft.com/en-us/power-bi/admin/service-premium-large-models#dataset-eviction

For example:

When many people are flushing the report at the same time, the model used to refresh the report will be loaded. Once there are a lot of models in the memory, the memory will be full, which will cause the subsequent refresh operation to fail to load and enter the queued state, , so that the report will be slow to load.

Then power bi will check whether the model in the memory has not been used for three minutes. If there is, the data model will become inactive, it will be evicted, and the new data model will be loaded. If the models in it are all active, it will check whether it can be evicted from the background operation, after all, the interactive operation takes precedence over the background operation

Power bi does not support changing the "Loading data..." information bar above.

You can use Power BI Premium Capacity Metrics to view the time layout of each scheduled refresh, Datasets Evictions, etc. to make some optimizations.

In your scenario, please set schedule refresh for different datasets at different times, and make sure that you are using the latest version of gateway.Please make sure that you don't schedule more than max parallel refreshes for the different nodes in these capacities.

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-premium-monitor-capacity

You can also check the following URL to optimize capacity:

https://docs.microsoft.com/en-us/power-bi/admin/service-premium-capacity-optimize

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.