Forum Discussion
Dataset not refreshing on PowerBI online
Hi Community,
My Dataset has stopped refreshing and giving the following error.
Error detail
Data source error: {"error":{"code":"DMTS_OAuthTokenRefreshFailedError","pbi.error":{"code":"DMTS_OAuthTokenRefreshFailedError","parameters":{"ConnectionDetails":"{\"kind\":\"SharePoint\",\"path\":\"https://xxxxxx.sharepoint.com/sites/GlobalMarketingTeam\"}","CredentialType":"OAuth2","DatasourceType":"SharePointList"},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"AADSTS700082: The refresh token has expired due to inactivity. The token was issued on 2023-07-19T00:11:44.5752384Z and was inactive for 90.00:00:00. Trace ID: 2317bdb2-7243-401e-beef-0d903f43d700 Correlation ID: f47f3312-b415-4885-a898-f8f6856f3fb1 Timestamp: 2023-11-08 17:50:56Z"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"AADSTS700082: The refresh token has expired due to inactivity. The token was issued on 2023-07-19T00:11:44.5752384Z and was inactive for 90.00:00:00. Trace ID: 2317bdb2-7243-401e-beef-0d903f43d700 Correlation ID: f47f3312-b415-4885-a898-f8f6856f3fb1 Timestamp: 2023-11-08 17:50:56Z"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2146233088"}}],"exceptionCulprit":1}}} Table: MDF Reporting.
Cluster URI: WABI-WEST-US-redirect.analysis.windows.net
Activity ID: e7a23e53-0211-4734-a91c-e02f2d94f71a
Request ID: 1775525e-10e0-deea-0988-ba914705e631
Time: 2023-11-08 17:50:56Z
My suspicion is that it is erroring out because the original .pbix file cannot be found in my c drive. I received a new machine from work and forgot to bring over the file. Origianlly created the dataset using PowerBI Desktop and then use PowerBI online to create the reports.
Is my suspicion correct? Is there a way to re-create the dataset and map it to the existing reports?
Kaz406 I think it's because you need to enter the credentials for the SharePoint list data source - go to the Dataset settings and find the 'Edit Credentials' link next to your data sources. Sign in for every source you have and that should work.
2 Replies
- AllisonKennedy
Community Champion
Kaz406 I think it's because you need to enter the credentials for the SharePoint list data source - go to the Dataset settings and find the 'Edit Credentials' link next to your data sources. Sign in for every source you have and that should work.
- Kaz406New Member
thank you AllisonKennedy Worked perfectly!