Forum Discussion

PowerbiGuRoo's avatar
PowerbiGuRoo
Advocate I
5 years ago

Refresh Keeps Increasing Each Day Even When Nothing Changed

I'm having an issue with our Power BI model loaded to the Service.  When I deploy the model, the refresh takes 20 minutes.  The next day, it will take about 40 minutes, and the next day after that ov...
Need Help
PowerbiGuRoo's avatar
PowerbiGuRoo
Advocate I
5 years ago

Hello Gilbert,

 

That is not the case.  Data is small and only a few records a day are added.  For example, if I refresh the model using the desktop and then load into the service, it only takes 20 mins to refresh, the next day it doubles, then the next day it doubles again..... It is very strange.  Since there are only a few records added each night, the incremental refresh takes longer.  After it takes 2 hours to refresh, I reload the model into the service where it only takes 20 minutes and then increases dramatically each day.

 

Kind Regards

  • GilbertQ's avatar
    GilbertQ
    Super User
    5 years ago

    Hi PowerbiGuRoo 

     

    Could it be that your source system is under more load and is causing the refresh to take longer?

     

    What happens if you schedule the refresh to run at say 11pm, how long does it take?

    • PowerbiGuRoo's avatar
      PowerbiGuRoo
      Advocate I
      5 years ago

      Hi Gilbert,

       

      No, there is no issue with the source system.  If I load the Power BI in the service, the first day it takes 20 minutes to run.  The 2nd day, even if only a few records are added it takes 40 minutes.  If I refresh it from the Power BI Desktop, it takes only 20 minutes using same data.  I reload the power bi .pbix back to the service it goes back down to 20 minute refresh times.  It don't make sense.  

       

      Kind Regards