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: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

pavel_levchuk

Incorrect time for Dataflow scheduled refresh

Submitted by on ‎08-08-2022 02:27 AM

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
See more ideas labeled with:
4 Comments (4 New)
Comments
AilsaTaoYe
Regular Visitor
‎08-08-2022 11:56 PM

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
‎08-09-2022 02:53 AM

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.

 

 

Anonymous
Not applicable
‎08-23-2022 01:40 AM

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
‎08-25-2022 02:33 AM

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.

 

 

 

Idea Statuses