This is a domain user account and doesn't require any special permissions. (We'll be installing this program using the procedures in this article.)Ĭreated an Active Directory account for the Power Pivot application pool. You'll need an instance of Analysis Services 2012 SP1 configured in Power Pivot mode in order to do this.Ĭonfigured Secure Store in your SharePoint Server farm.ĭownloaded Microsoft SQL Server 2012 SP1 PowerPivot for Microsoft SharePoint (spPowerPivot.msi). Before you beginīefore getting started, make sure you have:Ĭonfigured Excel Services in your SharePoint Server farm.Ĭonfigured a data model server in Excel Services. This includes installing Power Pivot for SharePoint on the servers in your farm, configuring a Power Pivot service application, and running some tests to make sure everything is working properly. In this scenario, we'll take a look at how to set up Power Pivot for SharePoint 2013. This scenario applies only to SharePoint Server 2013 and SQL Server 2012 with Service Pack 1 (SP1).

Power pivot 2013