PowerPivot for SharePoint Installation (SharePoint 2010)

Article
10/31/2012

PowerPivot for SharePoint is a collection of server components that provide query processing and management control over PowerPivot workbooks that you publish to SharePoint. Services include the Analysis Services engine and PowerPivot System Service.

Note

For information regarding SQL Server 2012 SP1 and installation with SharePoint Server 2013, see the following:

Business Intelligence Features and SharePoint 2013 (SQL Server 2012 SP1).
The “SQL Server 2012 SP1” section of Overview of SQL Server Servicing Installation.

Analysis Services provides server-side processing for Excel workbooks that contain PowerPivot data. PowerPivot System Service works alongside Analysis Services, adding SharePoint integration, load balancing and connection management. PowerPivot for SharePoint extends Excel Services by pairing its large scale data processing capability with the data rendering services that Excel provides.

To install PowerPivot for SharePoint, use the SQL Server 2012installation media.

For instructions on advanced deployment scenarios, see Deployment Checklist: Reporting Services, Power View, and PowerPivot for SharePoint and Deployment Checklist: Scale-out by adding PowerPivot Servers to a farm.