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.
| Scheduled | 31/10/2023, 7:02:22 am | 31/10/2023, 7:55:58 am | Completed |
| Scheduled | 31/10/2023, 9:02:05 am | 31/10/2023, 9:54:41 am | Failed |
| Scheduled | 31/10/2023, 10:31:23 am | 31/10/2023, 12:13:33 pm | Failed |
| Scheduled | 31/10/2023, 12:30:43 pm | 31/10/2023, 2:31:55 pm | Failed |
| Scheduled | 31/10/2023, 12:31:00 pm | 31/10/2023, 3:06:08 pm | Completed |
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.
