Excel Services & PowerPivot for SharePoint

Troubleshooting Excel Services and PowerPivot for SharePoint rendering and refreshing in the browser.

PowerPivot Scheduled data refresh does not work for first day of the month in SharePoint 2010

PowerPivot Scheduled data refresh does not work for first day of the month in SharePoint 2010

  • Comments 1
  • Likes

Issue:

PowerPivot for SharePoint 2010 scheduled data refresh does not work for the first day of the month, and an error is generated every two minutes. ULS shows:

PowerPivot Service             Data Refresh                   99 High     EXCEPTION: Microsoft.AnalysisServices.SharePoint.Integration.DataRefreshException: The data refresh job failed because it did not run within the time period allotted for running this schedule

 

Cause:

This looks to be a software defect.

 

Workaround:

If you refresh the workbook daily, the first day of the month will refresh fine.

If you refresh on the second day of the month the refresh will work.

The issue has been fixed in SharePoint 2013.

Comments
  • Do we have any fix available for it as of May 1st 2015?

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment