Forum Discussion

andreiak's avatar
andreiak
Advocate I
1 year ago

Refresh token expired error on multiple semantic models

Hi,

 

We experience a massive issue with all refreshes of semantic modules failing with the same error:

 

{"error":{"code":"DMTS_OAuthTokenRefreshFailedError","pbi.error":{"code":"DMTS_OAuthTokenRefreshFailedError","details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"AADSTS50173: The provided grant has expired due to it being revoked, a fresh auth token is needed. The user might have changed or reset their password. The grant was issued on '2024-01-23T11:41:08.4010000Z' and the TokensValidFrom date (before which tokens are not valid) for this user is ....

 

In addition, many reports show no data with the error "An exception occurred due to an on premise service issue"

 

There are multiple notifications in PBI Service "It looks loke the refresh token expired. Please go to this dataset's settings page, and reenteer the {CredentialsType} credentials for the {DatasourceType} data source."

 

I have reauthorized all models data source credentials, but it has not fixed the issue.

 

PBI Desktop has no problem with refreshing the data (mostly from PBI Dataflows).

The only way to fix it is to republish the report - there is no issue with refreshing the report semantic model after. But I'd like to avoid republishing a handred of reports across multiple workspaces.

 

Any recommendations would be much appreciated. 

I'd also like to understand a root cause - how could it be related to an user password if the issue affects multiple reports published by different users and end users have the issue with the visuals.

 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi andreiak,

    Try as following:

    Go to the Manage Connections and Gateways page, edit the credentials of the dataflow connection,then compare the result:


    If the issue persists, create new dataflow connections using OAuth 2.0 authentication, and then replace the data flow sources on each semantic model with the new connections.

     

    Best regards,

    Joyce

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