Forum Discussion

paulsnet1986's avatar
paulsnet1986
Helper I
2 years ago

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

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"
Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.