Dataset Refresh issue - Access token has expired, resubmit with a new access token

[debenaire]

Hi there I get this error on many of my Dataset refreshes. Noticed some blog posts on this happening at dataflow level. Any ideas please? Have been in to gateway and refreshed everything ansd all is live. The reports all link to Local dataflows. Thanks.

Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"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":"0b428487-49b9-4523-a510-7550495bf5e0"}},{"code":"Microsoft.Data.Mashup.ValueError.RequestUrl","detail":{"type":1,"value":"https://api.powerbi.com/powerbi/globalservice/v201606/clusterdetails"}}],"exceptionCulprit":1}}}
Cluster URI: WABI-UK-SOUTH-redirect.analysis.windows.net
Activity ID: 3c1da6f2-d5b9-4fb2-b40b-85f31cb2b987
Request ID: 0cac8e7a-4169-44c9-a7b6-0d09105da6f7
Time: 2023-11-03 01:30:41Z

[debenaire]

thank you for this. so for those having the same issue, this is because the on premise gateway was used for a dataflow

[lbendlin]

What do you mean by "local dataflow"?

[debenaire]

thanks fro the reply. i mean in the data source within the model it connects to local dataflows. See below.

[lbendlin · Accepted solution]

That's the name you gave the gateway connection. What made you use a gateway for this? It is not required unless you are trying to merge the dataflow source with an on-premise data source.