Monday, July 15, 2013

How to Install SQL Server BI Features with SharePoint 2013

SQL Server 2012 Service Pack 1 (SP1) supports Microsoft SharePoint 2013 Excel Services usage of Excel workbooks which containing data models and Reporting Services Power View reports.

Excel Services in SharePoint 2013 includes data model functionality to enable interaction with a PowerPivot workbook in the browser.
You do not need to deploy the PowerPivot solutions  for SharePoint 2013 add-in into the farm. You only need to install an Analysis Services server in SharePoint mode and register the server within the Excel Services Data Model settings.

Deploying the PowerPivot for SharePoint 2013 add-in enables additional functionality and features in your SharePoint farm.
The additional features include PowerPivot Gallery, Schedule Data Refresh, and the PowerPivot Management Dashboard.

The basic steps to deploy the PowerPivot for SharePoint 2013 add-in are the following:

1. Verify Excel Services is configured to use an in SharePoint mode. For more information, see Manage Excel Services data model settings.(SharePoint Server 2013)

2. Run spPowerPivot.msi to install the PowerPivot for SharePoint 2013 Configuration tool, SharePoint solution files, and data providers.

3. Run the PowerPivot for SharePoint 2013 Configuration tool to deploy and configure the PowerPivot features in SharePoint.

For information on how to download spPowerPivot.msi, see Microsoft® SQL Server® 2012 SP1 PowerPivot® for Microsoft® SharePoint®(
Microsoft® SQL Server® 2012 Service Pack 1 (SP1) (

spPowerpivot.msi: A Windows Installer package available with the SQL Server 2012 SP1 Feature Pack. The installer enhances the PowerPivot for SharePoint experience with more features such as PowerPivot Gallery and Schedule Data Refresh. The .msi deploys Analysis Services client libraries, the PowerPivot for SharePoint 2013 Configuration tool, and copies PowerPivot for SharePoint 2013 installation files to SharePoint servers.
After you run the .msi, you need to run PowerPivot for SharePoint 2013 Configuration to deploy the solutions and configure the farm.

Install and Uninstall the PowerPivot for SharePoint2013

To install PowerPivot for SharePoint 2013 with the Graphical user interface, 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.

To install PowerPivot for SharePoint 2013 with 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

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:


PowerPivot Configuration
SQL_ADOMD provider
AMO provider
Analysis Services common components for SharePoint 2013

To install PowerPivot for SharePoint 2013 with Quiet Command Line Installation for scripting

To perform a quiet installation:
Open a command prompt with administrator permissions.
Run the following command:

Msiexec.exe /i spPowerPivot.msi /q

You can use the /q or /quiet switches for a “quiet” installation that will not display any dialogs or warnings.

No comments:

Post a Comment