Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Incorrect time for Dataflow scheduled refresh

As you can see on the screenshot below all my Dataflows refreshed unsuccessfully in the morning.

It happened at 6:45 AM.

pavel_levchuk_1-1659950620848.png

But I have NOT scheduled refreshing my Dataflow for that time.

F.e. below are settings for one of my Dataflows.

As you can see my real scheduled time is 12:00 PM

pavel_levchuk_0-1659950936243.png

 

 

Status: Investigating

Hi @pavel_levchuk 

Can your dataflow refresh according to the time set by scheduled refresh now? 

 

Best Regards,
Community Support Team _ Ailsa Tao

Comments
AilsaTaoYe
Regular Visitor

Hi @pavel_levchuk 

Can these dataflows refresh successfully if you refresh them manually ? This happens when the Dataflow refresh is taking too long if there is a problem. Also, is your workspace to refresh Dataflow a Premium capacity ? If yes , you can refer to the workaround below .

AilsaTaoYe_0-1660028158608.png

Best Regards

pavel_levchuk
Regular Visitor

1/ No, I don't have Premium or PPU subscription, only Pro.

 

2/ When I trigger Dataflow refresh manually, it works.

 

BUT my point was that I don't want that Dataflow starts doing something randomly. As I stated previously I scheduled Dataflow refresh at 12:00 PM, not at 6:45 AM.

So I don't understand why Dataflow did nothing for almost 7hours and then started refreshing.

 

 

v-yetao1-msft
Community Support
Status changed to: Investigating

Hi @pavel_levchuk 

Can your dataflow refresh according to the time set by scheduled refresh now? 

 

Best Regards,
Community Support Team _ Ailsa Tao

pavel_levchuk
Regular Visitor

1/ My point was that from time to time Dataflow scheduled refresh does some refresh in a weird (unplanned) time. As I wanted to make sure that I control data refresh I stopped using scheduled refresh in Data Flow.

 

2/ To solve my issue I created a scheduled refresh in Power Automate. It works better, but...

from time to time Power Automate gets error 400.

 

So for me, it looks like the Data Flow engine is just an unreliable product.

It's not an enterprise-ready product and I am very disappointed by this.