Install or Uninstall the PowerPivot for SharePoint Add-in

  • Article

PowerPivot for SharePoint is a collection of middle-tier and backend services that provide PowerPivot data access in a SharePoint 2013 farm. The PowerPivot for SharePoint add-in (spPowerpivot.msi) is an installer package used to install the middle-tier components.

For diagrams of example deployments with the add-in, see Install SQL Server BI Features with SharePoint 2013 (SQL Server 2012 SP1).

  • Middle-tier: Enhancements to the PowerPivot functionality in SharePoint 2013. Functionality 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 2012 Analysis Management Objects.

    Note: This topic describes installing the middle-tier 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 (SQL Server 2012 SP1).

     

    For information on how to download spPowerPivot.msi, see Microsoft® SQL Server® 2012 SP1 Feature Pack (https://www.microsoft.com/en-us/download/details.aspx?id=35577).

  • Backend services: If you use PowerPivot for Excel to create workbooks that contain analytical data, you must have PowerPivot for SharePoint 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 and configuring the backend services, see the following:

    Install Analysis Services Server in SharePoint Mode for SharePoint 2013 (SQL Server 2012 SP1)

For more information on BI features and changes to installation with SQL Server 2012 SP1, see Install SQL Server BI Features with SharePoint 2013 (SQL Server 2012 SP1).

In this topic:

  • Where to Install spPowerPivot.msi?

  • Requirements and Prerequisites

  • To Install PowerPivot for SharePoint

  • Deploy the SharePoint Solution Files with the PowerPivot for SharePoint 2013 Configuration Tool

  • Uninstall the Add-in

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 2012 SP1 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.

Arrow icon used with Back to Top linkTop

Requirements and Prerequisites

  • Microsoft SharePoint Server 2013.

  • spPowerPivot.msi is 64-bit only, in accordance with the requirements of SharePoint products and technologies.

  • SQL Server 2012 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.

  • 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 (PowerPivot for SharePoint) (https://go.microsoft.com/fwlink/?LinkID=247828).

Arrow icon used with Back to Top linkTop

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.

 

User interface installation

To install PowerPivot for SharePoint 2013 with the graphical user interface, complete the following steps:

  1. Run SpPowerPivot.msi.

  2. Click Next on the Welcome page.

  3. Review and accept the license agreement, then click Next.

  4. On the Feature Selection page, all of the features are selected by default.

  5. Click Next.

  6. Click Install to install to finish the installation.

Arrow icon used with Back to Top linkTop

Command Line Installation

For a command-line installation, open a command prompt with elevated 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

Arrow icon used with Back to Top linkTop

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.

Note

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:

  1. Open a command prompt with administrator permissions.

  2. Run the following command:

    Msiexec.exe /i spPowerPivot.msi /q

Arrow icon used with Back to Top linkTop

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 it is available when you need it. Therefore when you install the spPowerPivot.msi, you can use the command line and to install the data providers and not the PowerPivot for SharePoint 2013 Configuration tool. The following command line is an example of including specific components in the installation:

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

Arrow icon used with Back to Top linkTop

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 farm level while the scope of the other file is the Web application level. The files are the following:

  • PowerPivotFarmSolution.wsp

  • PowerPivotFarm14Solution.wsp

  • PowerPivotWebApplicationSolution.wsp

The solution files are copied to the following folder:

C:\Program Files\Microsoft SQL Server\110\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:

  1. Go to Start, All Programs.

  2. Click Microsoft SQL Server 2012.

  3. Click Configuration Tools.

  4. Click PowerPivot for SharePoint 2013 Configuration.

For more information on the configuration tool, see PowerPivot for SharePoint 2013 Configuration tool (https://go.microsoft.com/fwlink/p/?LinkId=248415).

Arrow icon used with Back to Top linkTop

Uninstall or repair the add-in

Warning

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:

  1. Windows control panel: Select Microsoft SQL Server 2012 PowerPivot for SharePoint 2013. Click either Uninstall or Repair.

  2. 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

Arrow icon used with Back to Top linkTop

See Also

Concepts

Install SQL Server BI Features with SharePoint 2013 (SQL Server 2012 SP1)