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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
M_Capps
New Member

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:

M_Capps_0-1709910036924.png

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.

1 ACCEPTED SOLUTION
v-jiewu-msft
Community Support
Community Support

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.

vjiewumsft_0-1710143937255.png

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.

 

 

View solution in original post

2 REPLIES 2
v-jiewu-msft
Community Support
Community Support

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.

vjiewumsft_0-1710143937255.png

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
Super User
Super User

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors