PBI Service Dataset Refresh Failing

[GulianiG]

Please advise why our Refresh is failing!

Numbers truncated for privacy
But the error is pasted as it is so you can help
..............................................................................................
Data source error: {"error":{"code":"DMTS_OAuthTokenRefreshFailedError","pbi.error":{"code":"DMTS_OAuthTokenRefreshFailedError","parameters":{"ConnectionDetails":"{\"kind\":\"SharePoint\",\"path\":\"https://wmic.sharepoint.com/sites/Pnment/Powurces\"}","CredentialType":"OAuth2","DatasourceType":"SharePointList"},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"AADST82: The refresh token has expired due to inactivity. The token was issued on 2023-03-24T09:5477951Z and was inactive for 90.00:00:00.\r\nTrace ID: 0b2faa8d2c00\r\nCorrelation ID: dbfb4f28-5ce2-4e8a-9715-a1ad4a997291\r\nTimestamp: 2023-09-11 15:35:01Z"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"AADS082: The refresh token has expired due to inactivity. The token was issued on 2023-03-27951Z and was inactive for 90.00:00:00.\r\nTrace ID: 0b2faa85-28ba-47c9-b3e2c00\r\nCorrelation ID: dbfb4fce2-4e8a-9715-a1ad4a997291\r\nTimestamp: 2023-09-11 15:35:01Z"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2146088"}}],"exceptionCulprit":1}}}
Cluster URI: WABI-UMARY-redirect.analysis.windows.net
Activity ID: 4f555fed40a4d
Request ID: 399f5ad8-e8ab-420087
Time: 2023-09-11 15:35:01Z

[GulianiG · Accepted solution]

ChatGPT helped me
...............

Reauthenticate the Data Source:

• Go to your Power BI dataset in Power BI Service.
• Click on "Data source credentials" or "Edit credentials" (the exact wording may vary depending on your setup).
• Re-enter your credentials for the data source and ensure they are up to date. This step might involve providing your username and password or re-establishing the connection in another way.
  ..........................

[christinepayton · Accepted solution]

If this is happening in the web refresh, go to the datasource settings and click on the credentials and re-enter them. Make sure to select OAuth 2 if it's SPO, not anonymous. 

[GulianiG]

Thank you @christinepayton 
Your screenshot helped too 😋

[GulianiG · Accepted solution]

ChatGPT helped me
...............

Reauthenticate the Data Source:

• Go to your Power BI dataset in Power BI Service.
• Click on "Data source credentials" or "Edit credentials" (the exact wording may vary depending on your setup).
• Re-enter your credentials for the data source and ensure they are up to date. This step might involve providing your username and password or re-establishing the connection in another way.
  ..........................