Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
GulianiG
Helper II
Helper II

PBI Service Dataset Refresh Failing

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

2 ACCEPTED SOLUTIONS
GulianiG
Helper II
Helper II

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.
    ..........................

View solution in original post

christinepayton
Super User
Super User

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. 

 

image-90.png

View solution in original post

3 REPLIES 3
christinepayton
Super User
Super User

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. 

 

image-90.png

Thank you @christinepayton 
Your screenshot helped too 😋

GulianiG
Helper II
Helper II

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.
    ..........................

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors