Forum Discussion

ivan_tf's avatar
ivan_tf
New Member
2 years ago
Solved

cannot refresh dataset after changing my O365 password

Hi,

 

I published some Power BI reports to app.powerbi.com and they were working fine, but after I changed my O365 password a few weeks ago, the datasets of the reports cannot be refreshed anymore and I got the error message below whenever I try to refresh any dataset. The data is stored in SharePoint. Can anyone suggest a solution to solve this problem? Thanks in advance.

 

Data source error: {"error":{"code":"DMTS_OAuthTokenRefreshFailedError","pbi.error":{"code":"DMTS_OAuthTokenRefreshFailedError","parameters":{"ConnectionDetails":"{\"kind\":\"SharePoint\",\"path\":\"https://mycompany.sharepoint.com/sites/ITAPPTeamPlanner\"}","CredentialType":"OAuth2","DatasourceType":"SharePointList"},"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 '2023-03-20T10:53:30.6492309Z' and the TokensValidFrom date (before which tokens are not valid) for this user is '2023-11-02T00:56:32.0000000Z'. Trace ID: 2e1bc75c-ea46-4efa-b6c0-80c7ed415800 Correlation ID: 09c69d1c-8159-48c2-8810-9172dbee1794 Timestamp: 2023-11-02 02:04:15Z"}},{"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 '2023-03-20T10:53:30.6492309Z' and the TokensValidFrom date (before which tokens are not valid) for this user is '2023-11-02T00:56:32.0000000Z'. Trace ID: 2e1bc75c-ea46-4efa-b6c0-80c7ed415800 Correlation ID: 09c69d1c-8159-48c2-8810-9172dbee1794 Timestamp: 2023-11-02 02:04:15Z"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2146233088"}}],"exceptionCulprit":1}}} Table: CR Tracker.
Cluster URI: WABI-SOUTH-EAST-ASIA-redirect.analysis.windows.net
Activity ID: 980eb5c6-e664-45c3-ba24-178eb0e94445
Request ID: d1d5ac7f-028c-2046-8177-b663674e9f0b
Time: 2023-11-02 02:04:15Z

 

Best regards,

Ivan

Need Help
  • GilbertQ's avatar
    GilbertQ
    2 years ago

    Hi ivan_tf 

     

    You would need to go into each dataset, then click on the Dataset settings, and then click on Edit Credentials. When the window opens for your SharePoint file, select oAuth and then log in with your user account.

2 Replies

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    2 years ago

    Hi ivan_tf 

     

    You would need to go into each dataset, then click on the Dataset settings, and then click on Edit Credentials. When the window opens for your SharePoint file, select oAuth and then log in with your user account.

    • vsub14's avatar
      vsub14
      New Member
      2 years ago

      Hi,

       

      We have similar issue occurred when we changed MS Service acct password. We have 100+ reports in workspace with this ownership name. The refresh of these reports got failed due to the below error. Is there any way we can authenticate dynamically without manually checking each dataset.