Forum Discussion

MPereira_97's avatar
MPereira_97
Regular Visitor
2 years ago

Power BI Schedule Refresh

Hey Everyone, 

 

Recently we have been getting a lot of schedule refresh failures from last week, our Main Dataset is failing to schedule refresh and throwing 2-3 types of different random errors. We have downloaded the dataset and Refreshed it in the local pbix file it's working fine with the credentials but when it is in service it fails to update 80% of the time.

 

For eg - If we consider one Dataset 

it will run in the morning but after some time in the evenings, it will fail to refresh 3-4 times in a row, and again after some time it will start running. 

Scheduled31/10/2023, 7:02:22 am31/10/2023, 7:55:58 amCompleted
Scheduled31/10/2023, 9:02:05 am31/10/2023, 9:54:41 amFailed
Scheduled31/10/2023, 10:31:23 am31/10/2023, 12:13:33 pmFailed
Scheduled31/10/2023, 12:30:43 pm31/10/2023, 2:31:55 pmFailed
Scheduled31/10/2023, 12:31:00 pm31/10/2023, 3:06:08 pmCompleted

 

Mainly it's an "Access token has expired, resubmit with a new access token", "runtime" or "server error". 

Errors as below: -

{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"Access token has expired, resubmit with a new access token"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Error","detail":{"type":1,"value":"error \"Microsoft.Mashup.Engine1.Runtime.ValueException: [Expression.Error] The field 'pbi.error' of the record wasn't found.#(cr)#(lf) at Microsoft.Mashup.Engine1.Language.ValueCreator.CreateValueForThrow(IThrowExpression throwExpr)#(cr)#(lf) at Microsoft.Mashup.Engine1.Language.ValueCreator.<>c__DisplayClass23_0.<CreateValueForRecord>b__0(Int32 index)#(cr)#(lf) at Microsoft.Mashup.Engine1.Runtime.RecordValue.DemandRecordValue.get_Item(Int32 index)#(cr)#(lf) at Microsoft.Data.Mashup.ProviderCommon.MashupResource.TryGetValue(Func`1 getValue, IValue& value, String& errorMessage)#(cr)#(lf)Record\""}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"TokenExpired"}},{"code":"Microsoft.Data.Mashup.ValueError.RequestId","detail":{"type":1,"value":"2331c3a1-360b-466f-becb-6d31b10f91b1"}}

 

Steps Taken :- 

 

We have checked our Gateway and updated it to the latest October version (3000.194.16) made sure all the connections are connected online and also re-entered the credentials and saved. Furthermore, we also created new connections but its still showing us the same errors. 

 

Can someone please help in resolving this issue??

 

Thanks,

Mark P. 

 

Need Help

1 Reply