Forum Discussion

M_Capps's avatar
M_Capps
Regular Visitor
2 years ago
Solved

Auto Refresh Failure

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.

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

     

     

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.