Forum Discussion

mayurwadhwani's avatar
mayurwadhwani
Icon for Helper I rankHelper I
5 years ago
Solved

Refresh Visual on Service takes long time, if report kept for more than 5mins

Hello Experts,   I have report with 50 pages and it gets loaded in 2 minutes. Methodology is import. Say for example I am on page 1 on service and click at right top Refresh Visual which refreshes...
Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    Hi mayurwadhwani ,

     

    If your report is located in a shared capacity. I suggest you upgrade it to premium. 

     

    Import models are  loaded and removed from memory according to usage. An import model is loaded when it is queried (interactive operation), or if it needs to be refreshed (background operation).
     
    The removal of a model from memory is known as eviction. It's an operation Power BI can perform quickly depending on the size of the models. If the capacity isn't experiencing any memory pressure and the model isn't idle (i.e., actively in-used), the model can reside in memory without being evicted. When Power BI determines there is insufficient memory to load a model, the Power BI service will attempt to free up memory by evicting inactive models, typically defined as models loaded for interactive operations which have not been used in the last three minutes . If there are no inactive models to evict, the Power BI service attempts to evict models loaded for background operations. A last resort, after 30 seconds of failed attempts, is to fail the interactive operation. In this case, the report user is notified of failure with a suggestion to try again shortly. In some cases, models may be unloaded from memory due to service operations.
     

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

     

    Best Regards,

    Dedmon Dai

mayurwadhwani's avatar
mayurwadhwani
Icon for Helper I rankHelper I
5 years ago

Hi v-deddai1-msft  aj1973 ,

Report is almost optimized. Validated via Performance analyzer. How come report interaction is working fine when we open report and interact immediately. And if we do not interact with report for more than 5mins in that case its taking long time to interact and drive other visuals on a page.
If it would have been performance issue then it should have been reflected when we open report and interact. Entire performance of report is good when we open and interact.
Also, due to compliance issue its difficult for me to share data model snap.

Thanks,

Mayur

v-deddai1-msft's avatar
v-deddai1-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi mayurwadhwani ,

 

If your report is located in a shared capacity. I suggest you upgrade it to premium. 

 

Import models are  loaded and removed from memory according to usage. An import model is loaded when it is queried (interactive operation), or if it needs to be refreshed (background operation).
 
The removal of a model from memory is known as eviction. It's an operation Power BI can perform quickly depending on the size of the models. If the capacity isn't experiencing any memory pressure and the model isn't idle (i.e., actively in-used), the model can reside in memory without being evicted. When Power BI determines there is insufficient memory to load a model, the Power BI service will attempt to free up memory by evicting inactive models, typically defined as models loaded for interactive operations which have not been used in the last three minutes . If there are no inactive models to evict, the Power BI service attempts to evict models loaded for background operations. A last resort, after 30 seconds of failed attempts, is to fail the interactive operation. In this case, the report user is notified of failure with a suggestion to try again shortly. In some cases, models may be unloaded from memory due to service operations.
 

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

 

Best Regards,

Dedmon Dai