Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Scheduled refresh is not working but no issues with manual refresh

Submitted by Anonymous on ‎01-31-2023 05:53 AM

I have an odd one I have not seen before. I have a data model that has a scheduled refresh active, and Power BI notates when the next scheduled service will run but it never does. There are no issues manually refreshing. Works every time. I can't seem to find any previous issues on this either. Any help is appreciated.

Status: Investigating

Hi @Anonymous ,

 

Please provide more information like error message, do you have this issue below, if yes, it is a known issue and engineers are doing their best to fix it.

 

An error happened while reading data from the provider: 'Invalid operation. The connection is closed.'

 

Best regards.
Community Support Team_ Caitlyn

See more ideas labeled with:
10 Comments (10 New)
Comments
Anonymous
Not applicable
‎01-31-2023 05:56 AM

@Anonymous I have just raised a similar issue, mine is in a dataflow. Is your next refresh schedule showing as a time in the past?

This is mine taken today (31st Jan) at 13.45 but showing as next refresh due on 29th Jan

Twiggem_0-1675173324687.png

 

Anonymous
Not applicable
‎01-31-2023 06:02 AM

Exactly what is happening! For example, it will show the next refresh time but that time comes and goes and just sits there until I manually refresh, then it will flip to the next scheduled refresh time. Then that time comes and goes, and the viscious cycle continues. Going on for 2 days now.

 

Example: I manually refreshed the below at 6A this morning (1/31). The 5P 1/30 refresh never ran.

wegemmell_0-1675173688512.png

 

Anonymous
Not applicable
‎01-31-2023 07:33 AM

I have a couple datasets on the same refresh schedule. As a shot in the dark, I am adjusting one or two to see if the like-schedules are somehow causing the issue.

jaap_olsthoorn
Advocate II
Advocate II
‎01-31-2023 07:42 AM

Hey, I think you're also suffering from this issue:

 

Power BI scheduled refresh stopped refreshing with... - Page 3 - Microsoft Power BI Community

 

Our experience so far is that it fixes itself after a week. We do not know why it happens. MS was unhelpful for me, because they can't debug a refresh that never happened.

 

We need to hope someone from a "too big to fail" customer (Coca Cola, Disney or something) gets the issue too, then maybe the dev team will pick it up.

Anonymous
Not applicable
‎01-31-2023 07:46 AM

Thank you for that share. That is the issue I am experiencing. Okay, I will hope it corrects itself. It seems my only other option would be to re-publish the dataset and lineage reports. Thank you.

asubr
Frequent Visitor
‎01-31-2023 10:46 AM

i republished the dataset and lineage reports and still have this error in power bi service refresh.

Anonymous
Not applicable
‎01-31-2023 10:51 AM

Appreciate that feedback, @asubr. That saves me some time doing all that work for nothing. 

v-xiaoyan-msft
Community Support
Community Support
‎01-31-2023 10:19 PM
Status changed to: Investigating

Hi @Anonymous ,

 

Please provide more information like error message, do you have this issue below, if yes, it is a known issue and engineers are doing their best to fix it.

 

An error happened while reading data from the provider: 'Invalid operation. The connection is closed.'

 

Best regards.
Community Support Team_ Caitlyn

Anonymous
Not applicable
‎02-01-2023 05:49 AM

Hi, @v-xiaoyan-msft 

 

There are no error messages received. It simply skips right over the scheduled refresh time. The old refresh time will remain as the "next scheduled refresh" until I manually refresh the model, which there are no issues with. After the manual refresh is complete, the "next scheduled refresh" will change to the next refresh date/time that is scheduled. It then comes and goes. Hope this information helps.

 

As of this morning, it does look like the scheduled refreshes are running again. I am not sure if that is due to something the engineers have done, or if it is related to me changing the refresh times of the model, which I did last night in hopes it would help.

 

Thank you,

 

Wm

Prashant_leo
Regular Visitor
‎07-02-2024 08:52 AM

Hey guys, I am facing the same thing any updates on this?

Idea Statuses