PowerPivot – Scheduled data refresh get stuck in a loop (runs over and over).


I have had several customers experience the PowerPivot "scheduled data refresh" running over and over when setting the Schedule Details to Monthly and choosing a Day.

Refresh Settings:

As you can see below, the refresh runs over and over; it's stuck in a loop.  In this case every 5 seconds.  If the Data Model was larger and required more data to refresh, the duration would be longer.

We were able to fix this in the below CU:

Cumulative Update 4 for SQL Server 2012 SP2

http://support.microsoft.com/kb/3007556

 

FIX: Continuous refreshes occur after you configure scheduled data refresh in PowerPivot for SharePoint 2013

http://support.microsoft.com/kb/3023620

 

Important Note:

 

Run the "PowerPivot Configuration Tool" after Upgrading the Analysis Services POWERPIVOT Instance.
http://blogs.technet.com/b/excel_services__powerpivot_for_sharepoint_support_blog/archive/2015/03/12/run-the-quot-powerpivot-configuration-tool-quot-after-upgrading-analysis-services-powerpivot-instance.aspx  


Comments (0)

Skip to main content