Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

Schedule Refresh Timings

Hi,

I am facing an issue in Schedule Refresh. Suppose if I scheduled it for 4.00 PM IST then it executes at 5.35 PM IST, if I schedulef it for 3.30 PM then it executes at 4.55 PM. It is taking time randomly.

Do you have any idea how can I resolve this issue or its a bug. 

  • Anonymous's avatar
    Anonymous
    10 years ago

    kcantor , ankitpatira .. Below is the response from Micropsoft Support:

     

    Its due to the fact that currently there is only one scheduler per Cluster, used by both package refresh (file refresh from OneDrive) and model refresh (scheduled refresh). The delays are due to the queuing of all the refresh jobs.  The Product Group is working on a fix which will introduce two separate schedulers, one for package refresh, and one for model refresh. The fix is scheduled to be available in production in about a month.

13 Replies

  • ankitpatira's avatar
    ankitpatira
    Community Champion

    Anonymous This question is about power bi service as that is where you setup schedule refresh. When you setup a schedule refresh there can be a delay upto 1 hours and that is why you seeing it doesn't start at the exact time.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Ankit,

       

      Sometimes it takes 1.30 hr, sometimes takes 55 min.. how can I get exact time. I need to refresh at a particular time for users.

      • ankitpatira's avatar
        ankitpatira
        Community Champion

        Anonymous I don't think it can be triggered at exact time you can only specify times and it will trigger more or less near that. You can use Refresh History to view start and end times of previous refreshes and average timings.

  • When is this fix expected to the released ? We have few dashboards on queue waiting for this fix.

    • hongkwokkwok's avatar
      hongkwokkwok
      Helper I
      It got the same issue now my schedule is 6pm daily...but it refresh at 9:55, 7:55, 9:50... How can it fix?
      • Anonymous's avatar
        Anonymous
        Not applicable
        Same here in Germany aprox. 35 to 1.20 hrs After Scheduled Time
  • Anonymous's avatar
    Anonymous
    Not applicable

    execution timings are improved now.