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

[Markoff]

Hello community!

Can someone tell me, what Power BI (Service and Desktop) is doing when it displays following message??

This message appears in the upper right corner of the service when opening an existing report or when creating a new one based on an already processed/refreshed import dataset (!!!) within a premium capacity workspace. The message also appears within Power BI Desktop when using this dataset as a source.

The message appears appr. only once every 60 minutes when the dataset is not used within that time. After waiting until the report shows the result, all reports can be opened without getting the message after that. When the dataset is appr. 60 minutes not used anymore, the message pops up again when opening/creating a report based on the dataset.

Is it due to a cache invalidity setting or something like that? What does Power BI do while this message is shown (refresh/processing was done before in this import dataset)? How can we get rid of this message or better the time we have to wait for a response every 60 minutes?

Best regards,

Marco

[Anonymous · Accepted solution]

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.

[Markoff]

In the meantime I assume the cause for this is probably "dataset eviction"...

See https://docs.microsoft.com/en-us/power-bi/admin/service-premium-what-is ("How capacities function")

Does somebody have a good explanation/link/etc. how we can influence this dataset eviction by changing settings of the premium capacity? E.g. what exactly means "...the model isn't idle (i.e., actively in-used)..." --> minutes, hours, setting in capacity?