Dataset not refreshing on PowerBI online

[Kaz406]

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]

thank you @AllisonKennedy Worked perfectly! 

[AllisonKennedy · Accepted solution]

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

https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh#power-bi-gateway--...