09/10/2012 12:08:52

Copyright Notice

The information in this document is provided “as-is”. Information and views expressed in this document, including URL and other internet website references, may change without notice. This document does not provide you with any legal rights to any intellectual property in any Microsoft product. You may copy and use this document for your internal, reference purposes.

© 2012 Microsoft. All rights reserved.

PowerPivot and Microsoft SharePoint are trademarks of the Microsoft group of companies. All other trademarks are property of their respective owners.

Background

SQL Server 2012 PowerPivot for SharePoint 2013 provides enhanced PowerPivot functionality and experiences in your SharePoint 2013 farm. Functionality includes using workbooks as a data source and scheduled data refresh.

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 features in SharePoint. The following features are installed by default:

  • PowerPivot for SharePoint 2013. This feature includes the PowerPivot Web Service that provides the interface from SharePoint front-end servers to the PowerPivot System Service on SharePoint application servers.

  • Microsoft OLE DB Provider for Analysis Services (MSOLAP).

  • ADOMD.NET data provider.

  • SQL Server 2012 Analysis Management Objects.

 

Three of the files copied to the hard drive by the .MSI are SharePoint solution files. The scope of one solution file is the farm level while the scope of the other file is the site collection level. The files PowerPivotFarmSolution.wsp, PowerPivotFarm14Solution.wsp, and PowerPivotWebApplicationSolution.wsp are copied to the following folder:

C:\Program Files\Microsoft SQL Server\110\Tools\PowerPivotTools\SPAddinConfiguration\Resources

Requirements and Prerequisites

  • Microsoft SharePoint Server 2013.

  • The add-in is 64-bit only, which is a requirement of SharePoint products and technologies.

  • SQL Server 2012 Analysis Services (SSAS) server in SharePoint mode. Excel Services will use the server 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 member of the SharePoint Farm Administrators group.

  • For more information on PowerPivot for SharePoint requirements and pre-requisites, go to Hardware and Software Requirements (PowerPivot for SharePoint) (http://go.microsoft.com/fwlink/?LinkID=247828).

To Install PowerPivot for SharePoint

The SpPowerpivot.msi installation supports both a graphical user interface and a command-line installation. Both methods of installation require that you run the .msi with administrator privileges.

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.

 

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.

Deploy the Solution

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 (http://go.microsoft.com/fwlink/p/?LinkId=248415).

Installation and Configuration Assistance

Read the Release Notes for the Latest Product Information

The Release Notes provide supplemental information about product behaviors that apply only to this release or that are not documented in this release of Books Online. You can find Release Notes on the Release Notes Page (http://go.microsoft.com/fwlink/p/?LinkId=248389).