Dataflow Next Refresh set to a date in the past

[AliceW]

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.

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

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

[v-jayw-msft]

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

[taylorhawk]

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. 

[TTZ]

I experienced exactly the same - e.g.

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

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

[AliceW]

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

[GilbertQ]

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