Access token has expired, resubmit with a new access token Error message

[RobSpring]

HI,

We have been having issues with our data refresh for nearly 2 weeks now, below is the error message:

{"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":"<ccon>Downstream service call failed with status code '403'.</ccon>"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Error","detail":{"type":1,"value":"Access token has expired, resubmit with a new access token"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorCode","detail":{"type":1,"value":"TokenExpired"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorMessage","detail":{"type":1,"value":"Access token has expired, resubmit with a new access token"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}},{"code":"Microsoft.Data.Mashup.ValueError.RequestId","detail":{"type":1,"value":"d0162126-0497-47e9-a1b3-43d6ce773704"}}],"exceptionCulprit":1}}} Table: bookingsdetail.

We have raised a ticket and are providing logs, but anyhting we have tried isnt working. I have changed to sources away from dataflows, checked security settings, updated our gateway and some others. The affected table has a lot of transformations on it but it was working without issue before, and even when removing some of the data the error persists. 

Any help or ideas would be very appreciated!

[hayson-banico]

I got the same issue today in a Fabric data factory dataflow failed due to expired token from an AD Account password reset.

[pooja2117]

Did anyone get the solution? I have three dataflows which are using the webAPI's as their datasource. The report is failing with the same error which everyone mentioned earlier and haven't found any solution yet.

[MNXBITeam]

Has anyone found a solution? I am encountering the same issue today after a password reset.

[pooja2117]

I am facing the exact same issue with every refresh throwing same error with different table names. No solution found yet. 

[RobSpring · Accepted solution]

Hi, so the only thing that eventually solved the issue was to completely remove any use of data flows from the model. From ms support, the error was caused by the connection to a data flow staying open longer than the access token would allow, something around 60-70 mins. It's not really a solution but more a limitation of data flows. I hope this is useful, apologies I can't give a better solution. 

[RobSpring]

The main source is an SQL table that is being pulled into a semantic model. There are multiple merges from tables that are also SQL sources. This was previoulsy pulling from Dataflows but that was changed after MS support recomended that might be the issue. 

[lbendlin]

I hope your ticket is still open. If not, raise a new one, with higher priority.  Clearly something they need to fix.

[nberkun]

I'm having the same issue and it's clearly an auth error...

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":"Downstream service call failed with status code '403'."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Error","detail":{"type":1,"value":"Access token has expired, resubmit with a new access token"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorCode","detail":{"type":1,"value":"TokenExpired"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorMessage","detail":{"type":1,"value":"Access token has expired, resubmit with a new access token"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}},{"code":"Microsoft.Data.Mashup.ValueError.RequestId","detail":{"type":1,"value":"XXXXXXXXXXXXXXX"}}],"exceptionCulprit":1}}} Table: XXXXX.
Cluster URI: WABI-US-EAST2-C-PRIMARY-redirect.analysis.windows.net
Activity ID: 5f5d8ee7-c7a8-4393-9185-985f2d0af301
Request ID: ebb52fc3-08da-c6a4-c68c-b5c5cae5fff5
Time: 2024-05-10 14:52:39Z

[lbendlin]

Please provide more details. What is the data source? Is this going into a dataflow or a semantic model?