Share via


PowerPivot Configuration Tools

Configure, repair, or remove a SQL Server 2012 and SQL Server 2012 SP1 PowerPivot for SharePoint with the PowerPivot Configuration Tools.

The SQL Server 2012 SP1 Setup Wizard installs the PowerPivot Configuration Tool for SharePoint 2010 as well as a PowerPivot Configuration Tool for SharePoint 2013. This topic describes the general use of the two tools and the differences between them.

In this Topic:

  • Requirements for Using the Configuration Tools

  • Two Versions of the Configuration Tool

  • Overview of Using one of the PowerPivot Configuration Tools

  • Start One of the PowerPivot Configuration Tools

Requirements for Using the Configuration Tools

  • You must be a farm administrator.

  • You must be a server administrator on the Analysis Services instance (SharePoint 2010 only).

  • You must be db_owner on the farm’s configuration database.

  • There are no TCP/IP port requirements for using the configuration tools and therefore you should not have to configure your firewall to accommodate the configuration tools. The configuration tool expects the web applications and shared services are available as part of the SharePoint platform. You may need to configure your firewall for the Analysis Services server. For more information, see Configure the Windows Firewall to Allow Analysis Services Access.

Arrow icon used with Back to Top linkTop

Two Versions of the Configuration Tool

The SQL Server 2012 SP1 Setup Wizard installs the PowerPivot Configuration Tool for SharePoint 2010 as well as a PowerPivot Configuration Tool for SharePoint 2013.

The tools can only be used with a SQL Server 2012 or SQL Server 2012 SP1 instance of PowerPivot for SharePoint. Do not use them with SQL Server 2008 R2 installations.

Name

Supported version of SharePoint

Detailed Configuration

PowerPivot for SharePoint 2013 Configuration

SharePoint 2013

Configure or Repair PowerPivot for SharePoint 2013 (PowerPivot Configuration Tool)

PowerPivot Configuration Tool

SharePoint 2010 with SharePoint 2010 Service Pack 1 (SP1)

Configure or Repair PowerPivot for SharePoint 2010 (PowerPivot Configuration Tool)

Arrow icon used with Back to Top linkTop

How the Two Configuration Tools are Different

The two versions of the Configuration tool are similar but there are differences in the configuration steps the two tools run. The differences are due to changes between SharePoint 2010 and SharePoint 2013 as well as the architecture differences between the SQL Server 2012 SP1 version of PowerPivot for SharePoint and the previous versions of PowerPivot for SharePoint.

The following table describes new and changed features in the PowerPivot for SharePoint 2013 Configuration tool. The table also describes features in the PowerPivot Configuration Tool that are not in the PowerPivot for SharePont 2013 Configuration tool. The rows in the table are in the same order as the tabs in the configuration tools.

PowerPivot for SharePoint 2013 Configuration

PowerPivot Configuration Tool

The main page has a new option for PowerPivot Server for Excel Services. The option supports the new architecture with Analysis Services running outside of the SharePoint farm. You configure Excel Services to use one or more Analysis Services servers that are running in SharePoint mode.

PowerPivot Server in the new configuration tool

The 2010 tool includes the page Register SQL Server Analysis Services (PowerPivot) on Local Server to configure a local instance of Analysis Services. This page is not part of the 2013 tool because there is no local instance of Analysis Services.

AS service account in the old configuration tool

The page Create PowerPivot Service Application has an extra option of Upgrade Workbooks to enable data refresh. This option is not available in the 2013 tool.

upgrade workbooks in old configuration tool

The 2013 tool has a new page Configure PowerPivot Servers. This page supports the new architecture of Analysis Services running outside the SharePoint farm. By default, the server name that was typed on the main page in the text box PowerPivot Server for Excel Services, is also be listed on the Configure PowerPivot Servers.

Register PowerPivot servers new configuration tool

The 2013 tool has a new page Register PowerPivot addin as Excel Services Usage Tracker. SharePoint 2010 Excel Services does not track usage data for PowerPivot.

The 2010 tool includes the page Add MSOLAP.5 as a trusted Provider to register MSOLAP so that Excel Services in SharePoint 2010 can load PowerPivot models. This page is not part of the 2013 tool. SharePoint 2013 Excel Services does not use the MSOLAP provider to load models.

Arrow icon used with Back to Top linkTop

Overview of Using a PowerPivot Configuration Tool

When you start one of the PowerPivot Configuration Tools, the tool evaluates the existing installation to determine which operations are applicable. On a new installation, only the configuration task is available. After the server is configured, the remove task appears. If you started with a SQL Server 2008 R2 instance, upgrade will also be enabled in the list of available tasks.

If you are not familiar with Central Administration or Windows PowerShell, you can run the configuration tool as an alternative to complete a PowerPivot for SharePoint installation.

Additionally, the tool can detect whether the farm is configured or required features are missing. If the SharePoint program files are installed but the farm is not configured, the tool provides actions for configuring both the farm and the PowerPivot for SharePoint installation.

You can review the Script tab to learn and understand how to configure PowerPivot and SharePoint using Windows PowerShell. For more information, see the following:

Note

The tool does not configure Reporting Services. If you are adding Reporting Services to your SharePoint environment, you need to install and configure Reporting Services separately. For more information, see the following:

Arrow icon used with Back to Top linkTop

Start One of the PowerPivot Configuration Tools

  1. On the Start menu, point to All Programs, click Microsoft SQL Server 2012 , click Configuration Tools, and then click one of the following:

    • PowerPivot Configuration Tool.

    • OR

    • PowerPivot for SharePoint 2013 Confiugration.

    Note: The tools are available only when PowerPivot for SharePoint is installed on the local server.

  2. At startup, the configuration tools check the status of your installation and provide tasks that are valid for your installation.

  3. Depending on the current state of your installation, one or more of the following tasks can be performed:

    1. Click Configure or Repair PowerPivot for SharePoint to complete post-installation tasks, or to repair an installation.

    2. Click Remove Features, Services, Applications and Solutions to remove features and solutions from the farm.

    3. Click Upgrade Features, Services, Applications and Solutions to upgrade features and solutions that were installed using a previous version of PowerPivot for SharePoint.

    For example, the image shows the startup page of the PowerPivot Configuration for SharePoint 2013 tool.

    PowerPivot for SharePoint 2013 Configuration Tool

Each task is composed of individual actions that address some aspect of server configuration. For example, the configuration task includes actions for deploying solutions, creating a PowerPivot service application, activating features, and configuring data refresh. The list of actions will vary based on the current state of your installation. If an action is not needed, the tool excludes it from the task list.

When you click Run , the tool processes all actions in batch mode. Although each action appears as a separate item in the task list, all actions that are included in the task process together. Only actions that pass a validation check are processed. You might need to add or change some of the input values to pass the validation check.

Arrow icon used with Back to Top linkTop

For more information on the SharePoint 2010 SP1, see Download SharePoint Server 2010 SP1 (https://go.microsoft.com/fwlink/?LinkID=219697).

Use Windows PowerShell to Configure PowerPivot

PowerPivot Server Administration and Configuration in Central Administration

SharePoint Settings Submit feedback and contact information through Microsoft SQL Server Connect (https://connect.microsoft.com/SQLServer/Feedback).

Link

Description

Upgrade PowerPivot for SharePoint (PowerPivot Configuration Tool)

Describes the workflow that upgrades an existing installation that is already in a farm.

Remove PowerPivot for SharePoint (PowerPivot Configuration Tool)

Describes the workflow that removes PowerPivot for SharePoint services, solutions, and application pages from a farm.