Forum Discussion

Vikas_J's avatar
Vikas_J
Frequent Visitor
1 year ago

Error in data refresh

After sucessfully hosting dashboard on the Power BI services for atleast six months. i have started to get this error message :

The dashboard was hosted by some other member of the team and person is not available in the team now. How to resolve this?

 

 

  • Data source error{"error":{"code":"DMTS_OAuthTokenRefreshFailedError","pbi.error":{"code":"DMTS_OAuthTokenRefreshFailedError","details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"AADSTS50057: The user account is disabled. Trace ID: 30df9897-2973-40e2-b3a9-95b8e24b2c00 Correlation ID: 841ab715-8e43-4682-b8cc-44cf8ef952fd Timestamp: 2024-10-20 06:08:00Z"}}],"exceptionCulprit":1}}} Table: Digital.
  • Cluster URIWABI-WEST-US-redirect.analysis.windows.net
  • Activity ID91285a94-3933-4a7b-b224-cd5e737d8703
  • Request ID40927f0f-27cd-4bbe-bcc4-7e7897e4ff21
  • Time2024-10-20 06:08:02Z

1 Reply

  • Hi Vikas_J 
    DMTS_OAuthTokenRefreshFailedError, indicates that the OAuth token used for authentication has failed to refresh because the user account is disabled. Since the dashboard was hosted by a team member who is no longer available, you’ll need to update the credentials for the data source.

     

    • Go to the Power BI Service.
    • Navigate to the workspace where the dashboard is hosted.
    • Reassign the ownership of the dataset to an active team member.
    • In the Power BI Service, go to the dataset settings.
    • Find the section for Data source credentials.
    • Update the credentials with an active user’s account information.
    • Ensure that the new credentials have the necessary permissions to access the data sources.
    • Re-authenticate the data sources if needed.
    • After updating the credentials, manually refresh the dataset to ensure that the changes take effect.

     

    Hope this helps!!

    If this solved your problem, please accept it as a solution and kudos!!

     

    Best Regards,
    Shahariar Hafiz