Forum Discussion
PhilMitchell
4 months agoFrequent Visitor
Power BI Gen1 Dataflow scheduled refresh retried?
Hi, In the early hours of this morning, 2 am, the usual gen1 dataflows refreshes were triggered as scheduled. One of these failed with "internal error" for one of the tables. However, what I didn...
- 4 months ago
That second run 5 minutes later strongly suggests one of these internal behaviors:
- Transient failure recovery at the service layer
The “internal error” classification usually maps to ephemeral issues (capacity pressure, backend compute node recycling, connector timeouts). The Power BI service can occasionally re-queue or replay jobs when it detects infrastructure-level faults. - Scheduler reconciliation / orphaned job recovery
If the first attempt failed in a non-clean way (e.g., partial execution state), the scheduler may enqueue a follow-up execution to ensure consistency. - Capacity load balancing effects
Especially around 2 AM (a common refresh window), capacity contention can cause failures followed by quick resubmission once resources free up.
None of these are documented guarantees
- Transient failure recovery at the service layer
andrewsommer
Super User
4 months agoThat second run 5 minutes later strongly suggests one of these internal behaviors:
- Transient failure recovery at the service layer
The “internal error” classification usually maps to ephemeral issues (capacity pressure, backend compute node recycling, connector timeouts). The Power BI service can occasionally re-queue or replay jobs when it detects infrastructure-level faults. - Scheduler reconciliation / orphaned job recovery
If the first attempt failed in a non-clean way (e.g., partial execution state), the scheduler may enqueue a follow-up execution to ensure consistency. - Capacity load balancing effects
Especially around 2 AM (a common refresh window), capacity contention can cause failures followed by quick resubmission once resources free up.
None of these are documented guarantees
PhilMitchell
4 months agoFrequent Visitor
Wow andrewsommer , a fantastic and comprehensive response 😀. Thanks for this and I'll build my own retry workflow.