The PowerPivot for SharePoint 2013 infrastructure has several significant changes in the release of Microsoft SharePoint 2013 and Microsoft SQL Server 2012 Service Pack 1 (SP1). SharePoint 2013 natively handles many features that were previously considered PowerPivot for SharePoint features.
The loading and caching of the PowerPivot models are among these changes. In Microsoft SQL Server 2008 R2 and SQL Server 2012 on Microsoft SharePoint 2010 farms, the PowerPivot service application database contains the RedirectService schema that defines two tables and many stored procedures. These tables and the stored procedures were used to track and maintain the mapping of PowerPivot databases to PowerPivot service applications. Instead, the mapping is maintained by Excel Calculation Services in SharePoint 2013.
The data refresh mechanism that is used to process PowerPivot models is also overhauled and is integrated with Excel Calculation Services. Instead of storing the DataRefresh schedule in the PowerPivot service application database, the PowerPivot for SharePoint 2013 stores the DataRefresh schedule in the workbook metadata. The obsolete tables and the related stored procedures that maintain the data refresh schedules are removed from the DataRefresh service application database.