TokenExpired Error After Password Change - Flows That Reference Other Flows Only

[paulsnet1986]

I recently changed my O365 login and a couple of my Dataflows failed to refresh. I'm getting the TokenExpired error. After reviewing I think these are failing because they use other Dataflows as data sources.

However, there doesn't appear to be a way for me to update my credentials in the Query as suggested in the documentation. I went into the Dataflow and added a table from the same source, and got the warning that adding a new table with new credentials from my Gateway will apply to all tables in the Dataflow (which is what I want), but that doesn't happen. The preview of the new table loads, but the rest of the tables still give me an error. This prevents the query from being saved - I get the "Failed To Analyze Query" error. 

Has anyone else run into this??

https://learn.microsoft.com/en-us/power-query/change-gateway-dataflow

Reason = TokenExpired

Error = 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"

[v-xiandat-msft]

Hi @paulsnet1986 ,

Let’s troubleshoot this issue and find a solution:

1. Upgrade Your Gateway:

   • Ensure you’re using the latest version of the gateway. Sometimes, token refresh implementations change, and upgrading ensures you have the most up-to-date version.
   • Capture gateway logs after upgrading to identify any issues related to token expiration.

2. Remove and Recreate Credentials:

   • Consider removing all existing credentials associated with the dataflow and recreate them. This step can sometimes resolve authentication problems in the Power BI service.

3. Check Dataflow Timeout Settings:

   • Verify that the timeout settings for your dataflow are not causing the token to expire prematurely.
   • Adjust these settings if necessary to prevent token expiration

Below is the post will help you:

Dataflow Error: Access token has expired resubmit ... - Page 3 - Microsoft Fabric Community

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.