cannot refresh dataset after changing my O365 password

[ivan_tf]

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

[GilbertQ · Accepted solution]

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]

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.