Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!See when key Fabric features will launch and what’s already live, all in one place and always up to date. Explore the new Fabric roadmap
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.
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.