Auto Refresh Failure

[M_Capps]

I sporadically receive the 'Refresh Failed' email generated by PBI Service on reports that I have published.  It states:

An error occurred while processing the data in the dataset.

Refresh failed:

<dashboard name> has failed to refresh.
Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support.

{"error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","pbi.error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"<ccon>The credentials provided for the SharePoint source are invalid.

However, when I go to the service portal to check the credentials and refresh status everything looks fine:

I do a manual refresh and everything goes through without issue or needing to change credentials.  Our dashboards update at least once a day, some update multiple times a day, but the 'Refresh Failed' email is only generated once a week at most.   Any insights would be greatly appreciated.

[v-jiewu-msft · Accepted solution]

Hi @M_Capps ,

Please try the following methods and check if they can solve your problem:

1.Try to refresh the data in the desktop and save.

2.Republish the report in a different workspace and refresh it.

3.Download the latest version of Desktop and republish to power bi service.

4.If you have a dashboard related to the dataset, try to delete the dashboard.

5.You can also view the following link to learn more about inter service error.

Solved: Re: Refresh Failed - Internal Service Error - Page 2 - Microsoft Fabric Community

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Go to the semantic model data sources section and refresh the OAUTH2 token of your sharepoint connection.