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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
GulianiG
Advocate I
Advocate I

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
Advocate I
Advocate I

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
Solution Sage
Solution Sage

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
Solution Sage
Solution Sage

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
Advocate I
Advocate I

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors