11/22/2013 16:18:42
This Readme document contains information about how to install Microsoft® SQL Server 2014 PowerPivot for SharePoint 2013. The most up-to-date version of this file is available online at the Microsoft Download Center: SQL Server 2014 PowerPivot for SharePoint 2013 (http://go.microsoft.com/fwlink/p/?LinkId=301738).
Copyright Notice
The information in this document is provided “as-is”. Information and views expressed in this document, including URLs 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.
© 2014 Microsoft. All rights reserved.
Microsoft SQL Server and Microsoft SharePoint are trademarks of the Microsoft group of companies. All other trademarks are property of their respective owners.
Background
SQL Server 2014 PowerPivot for SharePoint 2013 provides enhanced PowerPivot functionality and experiences in a SharePoint 2013 farm. Functionality includes using workbooks as a data source, scheduled data refresh, the PowerPivot Gallery, and the PowerPivot Management Dashboard.
PowerPivot for SharePoint 2013 is available in a Microsoft Windows Installer package (SpPowerpivot.msi) that deploys Analysis Services client libraries and copies PowerPivot for SharePoint 2013 installation files to the local computer. The installer does not deploy or configure any features in SharePoint. The following files are installed on the local company by default:
PowerPivot for SharePoint 2013. This includes the PowerPivot solution files for SharePoint 2013 and the PowerPivot for SharePoint 2013 Configuration Tool to deploy these solution files and configure PowerPivot in SharePoint.
Microsoft OLE DB Provider for Analysis Services (MSOLAP).
ADOMD.NET data provider.
SQL Server 2014 Analysis Management Objects.
SpPowerpivot.msi installs three SharePoint solution files. The scope of one solution file is the farm level while the scope of the other files is the site collection level.
PowerPivotFarmSolution.wsp
PowerPivotFarm14Solution.wsp
PowerPivotWebApplicationSolution.wsp
The files are copied to the following folder:
C:\Program Files\Microsoft SQL Server\120\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 2014 Analysis Services (SSAS) server in SharePoint mode. Excel Services uses this server as a PowerPivot Server. Analysis Services can run on the local or a remote computer.
To deploy PowerPivot for SharePoint 2013 by using the PowerPivot for SharePoint 2013 Configuration tool, the current user must be an administrator on the local 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/p/?LinkID=301746).
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 is not 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:
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 for SharePoint 2013 Configuration Tool (http://go.microsoft.com/fwlink/p/?LinkId=301745).
Installation and Configuration Assistance
The SQL Server product documentation on the MSDN Library is the primary documentation for installing and configuring PowerPivot for SharePoint 2013. For more information on installing and uninstalling the .msi, see Install or Uninstall the PowerPivot for SharePoint Add-in (http://go.microsoft.com/fwlink/p/?LinkID=301747).
For assistance installing PowerPivot for SharePoint 2013, see PowerPivot for SharePoint Installation (http://go.microsoft.com/fwlink/p/?LinkId=301752).
For more information and community support, go to the forum at, SQL Server PowerPivot for SharePoint (http://go.microsoft.com/fwlink/p/?LinkId=301750).
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 the current release of Books Online. You can find Release Notes on the Release Notes Page (http://go.microsoft.com/fwlink/p/?LinkId=296445).