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


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 (1)

  1. Raja says:

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