Forum Discussion
Aditya_V_Vernek
3 years agoRegular Visitor
Dataset refresh Failing at a particular time
Hello all , I have scheduled 3 refreshes , the problem is refresh is failing at a particuler time and its compleating perfectly in other times ... what could be the problem please help.
Aditya_V_Vernek
3 years agoRegular Visitor
Data Source is Sql Server
- cassidy3 years agoPower Participant
So you hit the 5 hour Premium Capacity refresh limit, but since then it's refreshed normally at those same Start Times.
How often do you hit the 5 hour limit?
With SQL Server as the source, there can be activity on the Server that hurts your refresh, but I'd think that would result in a SQL Timeout error and not the Premium Capacity 5 hour limit.