cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Partisan
Post Partisan

Dataflow Next Refresh set to a date in the past

Hello team,

Something very alarming happened to a dataflow. The hourly-scheduled refreshes seemed to work just fine, but the latest data brought in the dataset was from 9 days ago!

Looking at the dataflow, I saw that the 'Refreshed' column showed today as the latest date/time, but the 'Next Refresh' column showed June 16th, 4 PM; incidentally, this is when the latest data was brought in the dataset.

 

Next Refresh 2.png

 

 

I went and disabled and then enabled the automatic refresh. The "next Refresh' is in the future.

 

Next Refresh 3.png

 

 

 

I refreshed the dataflow and the dataset and the newest data are in.

 

What happened? This is a serious bug that went undetected. What do I need to do to ensure it doesn't happen again in the future?

Thank you,

Alice

5 REPLIES 5
Highlighted
Super User IV
Super User IV

Re: Dataflow Next Refresh set to a date in the past

What I would do, is to have a process to check that the dataset refreshes are happening as expected.

I use the Power BI REST APIs too ensure and monitor the dataset refreshes. If they are not refreshed I then immediately know about it.

Here is a link to the Power BI REST APIs https://docs.microsoft.com/en-us/rest/api/power-bi/dataflows




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

Proud to be a Super User!







Power BI Blog

Highlighted
Frequent Visitor

Re: Dataflow Next Refresh set to a date in the past

I experienced exactly the same - e.g.

 

TTZ_0-1595890119457.png

and as you suggested, I disabled it and enabled it again. Then it fixed itself.

TTZ_1-1595890167377.png

 

I totally agree that it is a serious bug with no warnings. I discovered it as my report data is not matching during testing. 

 

It would be good if the Dataflow team can provide some feedback on this and how we can prevent this from happening again.

 

Thanks for sharing your post,

 

Ting

Highlighted
Post Partisan
Post Partisan

Re: Dataflow Next Refresh set to a date in the past

So it's not just me... An official response would be great. Yes, checking it on our side is good, but them fixing it would be even better...

Highlighted
New Member

Re: Dataflow Next Refresh set to a date in the past

Having the same issue as well, and it has happened multiple times to me. The only fix I have found is to turn refresh off and turn it back on. Really would like to know how we can make sure Microsoft is working on a fix. 

Highlighted
Community Support
Community Support

Re: Dataflow Next Refresh set to a date in the past

Hi @AliceW 

 

You could try to open a support ticket. If you have a Pro account it is free.

Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution to help the other members find it.

Helpful resources

Announcements
Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Don't miss the Power BI Dev Camp this week!

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors