PowerPivot for SharePoint Installation (SharePoint 2010)
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.
In This Section
PowerPivot for Excel Installation
Install PowerPivot for SharePoint
Install the Analysis Services OLE DB Provider on SharePoint Servers
Install ADOMD.NET on Web Front-End Servers Running Central Administration
Install ADO.NET Data Services to support data feed exports of SharePoint lists
Install PowerPivot from the Command Prompt
Uninstall PowerPivot for SharePoint
Repair PowerPivot for SharePoint
Initial Configuration (PowerPivot for SharePoint)