Install or Uninstall the PowerPivot for SharePoint Add-in (SharePoint 2013)
PowerPivot for SharePoint 2013 is a collection of application server components and back-end services that provide PowerPivot data access in a SharePoint Server 2013 farm. The PowerPivot for SharePoint add-in (spPowerpivot.msi) is an installer package used to install the application server components.
The add-in is not required for SharePoint 2010 deployments.
The add-in is not required on a single server deployment that includes SharePoint 2013 and Analysis Services in SharePoint mode. The components installed by the add-in are included when you install an Analysis Services server in SharePoint mode. For diagrams of example deployments with the add-in, see Deployment Topologies for SQL Server BI Features in SharePoint.
Note: This topic describes installing the PowerPivot solution files and PowerPivot for SharePoint 2013 Configuration tool. After the installation, see the following topic for information on the configuration tool and additional features, Configure PowerPivot and Deploy Solutions (SharePoint 2013).
For information on how to download spPowerPivot.msi, see Microsoft® SQL Server® 2014 PowerPivot® for Microsoft SharePoint®.
In this topic:
Background
Application Server: PowerPivot functionality in SharePoint 2013 includes using workbooks as a data source, scheduled data refresh, and the PowerPivot Management Dashboard.
PowerPivot for SharePoint 2013 is a Microsoft Windows Installer package (spPowerpivot.msi) that deploys Analysis Services client libraries and copies PowerPivot for SharePoint 2013 installation files to the computer. The installer does not deploy or configure PowerPivot features in SharePoint. The following components install by default:
PowerPivot for SharePoint 2013. This component includes PowerShell scripts (.ps1 files), SharePoint solution packages (.wsp), and the PowerPivot for SharePoint 2013 configuration tool to deploy PowerPivot in a SharePoint 2013 farm.
Microsoft OLE DB Provider for Analysis Services (MSOLAP).
ADOMD.NET data provider.
SQL Server Analysis Management Objects.
Backend services: If you use PowerPivot for Excel to create workbooks that contain analytical data, you must have Excel Services configured with a BI server running Analysis Services in SharePoint mode to access that data in a server environment. You can run SQL Server Setup on a computer that has SharePoint Server 2013 installed, or on a different computer that has no SharePoint software. Analysis Services does not have any dependencies on SharePoint.
For more information on installing, uninstalling, and configuring the backend services, see the following:
Where to Install spPowerPivot.msi?
A recommended best practice is to install spPowerPivot.msi on all servers in the SharePoint farm for configuration consistency, including application servers and web-front end servers. The installer package includes the Analysis Services data providers as well as the PowerPivot for SharePoint 2013 configuration tool. When you install spPowerPivot.msi you can customize the installation by excluding individual components.
Data providers: Several SharePoint and SQL Server technologies use the Analysis Services data providers including Excel Services, PerformancePoint Services, and Power View. Installing spPowerPivot.msi on all SharePoint servers ensures the full set of Analysis Services data providers and PowerPivot connectivity is consistently available across the farm.
Note
You must install the Analysis Services data providers on a SharePoint 2013 server using spPowerPivot.msi. Other installer packages available in the SQL Server 2014 Feature Pack are not supported because these packages do not include the SharePoint 2013 support files that the data providers require in this environment.
Configuration Tool: The PowerPivot for SharePoint 2013 configuration tool is required on only one of the SharePoint servers. However a recommended best practice in multi-server farms is to install the configuration tool on at least two servers so you have access to the configuration tool if one of the two servers is offline.
Requirements and Prerequisites
Microsoft SharePoint Server 2013.
spPowerPivot.msi is 64-bit only, in accordance with the requirements of SharePoint products and technologies.
A SQL Server 2014 Analysis Services (SSAS) server in PowerPivot mode. Excel Services will use the SQL Server Analysis Services instance as a PowerPivot server. Analysis Services can run on the local or a remote computer.
Permissions: To install PowerPivot for SharePoint 2013, the current user is required to be an administrator on the computer and a SharePoint Farm Administrators group.
For more information on PowerPivot for SharePoint requirements and pre-requisites, go to Hardware and Software Requirements for Analysis Services Server in SharePoint Mode (SQL Server 2014).
To Install PowerPivot for SharePoint
The spPowerpivot.msi installer package supports both a graphical user interface and a command-line mode. Both methods of installation require that you run the .msi with administrator privileges. After the installation, see the following topic for information on the configuration tool and additional features, Configure PowerPivot and Deploy Solutions (SharePoint 2013).
User interface installation
To install PowerPivot for SharePoint 2013 with the graphical user interface, complete the following steps:
Run SpPowerPivot.msi.
Click Next on the Welcome page.
Review and accept the license agreement, then click Next.
On the Feature Selection page, all of the features are selected by default.
Click Next.
Click Install to install to finish the installation.
Command Line Installation
For a command-line installation, open a command prompt with administrative permissions, and then run the spPowerPivot.msi. For example:
Msiexec.exe /i SpPowerPivot.msi.
To create an installation log, use the standard MsiExec logging switches. The following example creates the log file "Install_Log.txt" using the "v" verbose logging switch.
Msiexec.exe /i SpPowerPivot.msi /L v c:\test\Install_Log.txt
Quiet Command Line Installation for scripting
You can use the /q or /quiet switches for a "quiet" installation that will not display any dialogs or warnings. The quiet installation is useful if you want to script the installation of the add-in.
Important
If you use the /q switch for a silent command line installation, the end-user license agreement will not be displayed. Regardless of the installation method, the use of this software is governed by a license agreement and you are responsible for complying with the license agreement.
To perform a quiet installation
Open a command prompt with administrator permissions.
Run the following command:
Msiexec.exe /i spPowerPivot.msi /q
Command Line Installation to include specific components
The PowerPivot for SharePoint 2013 Configuration tool is not required on every SharePoint server, however it is recommended to install it on at least two servers so the configuration tool is available when you need it.
When you install the spPowerPivot.msi, you can use the command line options to install specific items, such as the data providers and not the PowerPivot for SharePoint 2013 Configuration tool. The following command line is an example of installing all components except the configuration tool:
Msiexec /i spPowerPivot.msi AGREETOLICENSE="yes" ADDLOCAL=" SQL_OLAPDM,SQL_ADOMD,SQL_AMO,SQLAS_SP_Common"
| Option | Description |
|---|---|
| Analysis_Server_SP_addin | PowerPivot Configuration |
| SQL_OLAPDM | MSOLAP |
| SQL_ADOMD | ADOMD.net provider |
| SQL_AMO | AMO provider |
| SQLAS_SP_Common | Analysis Services common components for SharePoint 2013 |
Deploy the SharePoint Solution Files with the PowerPivot for SharePoint 2013 Configuration Tool
Three of the files copied to the hard drive by spPowerPivot.msi are SharePoint solution files. The scope of one solution file is the Web application level while the scope of the other files is the farm level. The files are the following:
PowerPivotFarmSolution.wspPowerPivotFarm14Solution.wspPowerPivotWebApplicationSolution.wsp
The solution files are copied to the following folder:
C:\Program Files\Microsoft SQL Server\120\Tools\PowerPivotTools\SPAddinConfiguration\Resources
Following the .msi installation, run the PowerPivot for SharePoint 2013 Configuration Tool to configure and deploy the solutions in the SharePoint farm.
To start the configuration tool
From the Windows Start screen type "power" and in the Apps search results, click PowerPivot for SharePoint 2013 Configuration. Note that the search results may include two links because SQL Server setup installs separate PowerPivot configuration tools for SharePoint 2010 and SharePoint 2013. Make sure you start the PowerPivot for SharePoint 2013 Configuration tool.
Or
Go to Start, All Programs.
Click Microsoft SQL Server 2014.
Click Configuration Tools.
Click PowerPivot for SharePoint 2013 Configuration.
For more information on the configuration tool, see PowerPivot Configuration Tools.
Uninstall or repair the add-in
Caution
If you uninstall spPowerPivot.msi the data providers and the configuration tool are uninstalled. Uninstalling the data providers will cause the server to be unable to connect to PowerPivot.
You can uninstall or repair PowerPivot for SharePoint 2013 using one of the following methods:
Windows control panel: Select Microsoft SQL Server 2012 PowerPivot for SharePoint 2013. Click either Uninstall or Repair.
Run the spPowerPivot.msi and select the Remove option or the Repair option.
Command Line: To repair or uninstall PowerPivot for SharePoint 2013 using the command line, open a command prompt with administrator permissions and run one of the following commands:
To Repair, run the following command:
msiexec.exe /f spPowerPivot.msi
OR
To uninstall, run the following command:
msiexec.exe /uninstall spPowerPivot.msi