Contents
The first step in configuring Power Pivot in a SharePoint Server 2013 farm is to install SQL Server 2012 SP1 PowerPivot for Microsoft SharePoint (sppowerpivot.msi) on each server in the farm. Use the following procedure to run sppowerpivot.msi on each server in your farm.
How to create a service application for Power Pivot?
In the Power Pivot Configuration Tool, in the left pane, select Create PowerPivot Service application. On the Parameters tab, clear the Include this action in the task list check box. This will prevent the tool from creating a service application for Power Pivot. We will create the Power Pivot service application manually later.
How to create an Active Directory account for Power Pivot?
Created an Active Directory account for the Power Pivot unattended data refresh account. This is a domain user account and must have read permissions to the data sources that you plan to use for your Power Pivot reports. It should be a unique account created for this purpose.
Click Start, click All Programs, click Microsoft SharePoint 2013 Products, right-click SharePoint 2013 Management Shell, and then click Run as Administrator. At the Microsoft PowerShell Command Prompt, type the following syntax (press ENTER after each line):
Which is the default name for Power Pivot?
The default name is Default Power Pivot Service Application. Select the name of the services application to open the Power Pivot Management Dashboard for the service application opens. On first use, the dashboard takes several minutes to load. For more information, see Verify a Power Pivot for SharePoint Installation.
What kind of server is needed for Power Pivot?
You must be a local administrator to run SQL Server Setup. SharePoint Server enterprise edition is required for Power Pivot for SharePoint. You can also use the evaluation enterprise edition. The computer must be joined to a domain in the same Active Directory forest as the Office Online Server (SharePoint 2016) or Excel Services (SharePoint 2013).