cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Shubham Member
Member

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. 

1 ACCEPTED SOLUTION

Accepted Solutions
Shubham Member
Member

Re: Schedule Refresh Timings

@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 13
ankitpatira Super Contributor
Super Contributor

Re: Schedule Refresh Timings

@Shubham 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.

Shubham Member
Member

Re: Schedule Refresh Timings

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 Super Contributor
Super Contributor

Re: Schedule Refresh Timings

@Shubham 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.

Shubham Member
Member

Re: Schedule Refresh Timings

Thanks @ankitpatira . I will open a Support ticket.

Highlighted
kcantor Super Contributor
Super Contributor

Re: Schedule Refresh Timings

This is one of my biggest issues with scheduled refreshes as I work from a laptop. when the laptop is off or sleeping it kills the gateway. It would be helpful if the scheduled refresh was a little more reliable but what I am currently doing (along with requesting a desktop for gateway only) is to use the manual refresh option  at set times as well as having the schedule set. If I know I will be away from my computer, I will refresh before I leave.

While it is inconvenient, It takes less than a second to hit the refresh button and, being honest, PowerBI is always open on my computer. I use it quite a bit.



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




Shubham Member
Member

Re: Schedule Refresh Timings

@kcantor I think you have installed gateway on your local machine, in my case it is installed on a server in US time zone which is running 24*7. Still getting issue. Smiley Sad

Shubham Member
Member

Re: Schedule Refresh Timings

@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.

kcantor Super Contributor
Super Contributor

Re: Schedule Refresh Timings

Thank you for sharing that answer. I appreciate knowing a fix is on the way.



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




LAmbro Frequent Visitor
Frequent Visitor

Re: Schedule Refresh Timings

Lots of our Power BI dashboard needs to scheduled once our data loads completes so please let us know the expected time for this fix

 

 

We are seeing another weird issue in the scheduler, though we scheduled to run our dashboard on a daily basis (once a day). The refresh history sometimes shows the data refresh has happened more than onc per day. Attaching a screenshotC:\Users\lambro\Desktop\Refresh_History.png

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 331 members 3,739 guests
Please welcome our newest community members: