SharePoint Administration (PowerPivot for SharePoint)

In a deployment of SQL Server PowerPivot for SharePoint, Analysis Services is an integrated member of the farm, where the PowerPivot System Service runs as a shared service application that is managed through Central Administration.

All configuration and oversight for PowerPivot service applications, usage data collection, scheduled data refresh, server monitoring, and diagnostics are available to PowerPivot for SharePoint server instances through Central Administration and the common SharePoint infrastructure. All self-service content management for PowerPivot libraries and content types is through application pages on SharePoint sites.

Using other tools and applications for managing PowerPivot services or content is not supported. You should never use SQL Server configuration tools, Internet Information Services (IIS) Manager, or system tools to manage the server components installed through SQL Server PowerPivot for SharePoint. By always using Central Administration to enable or disable services or change service accounts, you are assured that the changes you make flow through the farm and are applied identically to all PowerPivot server instances in the farm.

Click the following links for more information:

Service Administration in Central Administration

Service Administration in PowerPivot Management Dashboard

Content Management in Team Sites

SharePoint Farm Infrastructure used for PowerPivot Deployments


Windows PowerShell is used for script-based administration in a SharePoint farm. For more information about PowerShell support for a PowerPivot for SharePoint installation, see PowerShell Configuration Script (PowerPivot for SharePoint).

After PowerPivot for SharePoint is installed, Central Administration provides PowerPivot service administration through the following pages:



System Settings

Manage Servers in Farm

Use this page to quickly determine whether SQL Server PowerPivot for SharePoint is installed on any given server in the farm. Each server shows a list of the services that run on it.

Manage Farm Features

Use this page to deactivate or re-activate the Analysis Services Integration Feature for the farm. Feature activation is a prerequisite to creating PowerPivot service applications in the farm.

Manage Services on Server

Use this page to determine whether SQL Server PowerPivot for SharePoint is hosted on the server. From this page, you can configure the type of requests the Analysis Services service supports from this page. For more information, see Configure Dedicated Data Refresh or Query-Only Processing.

Manage Farm Solutions

Use this page to view information about the PowerPivot solution that adds PowerPivot connectivity to web front-end servers in the farm. Knowing the version of the solution is useful for upgrading PowerPivot in a farm. For more information, see Upgrade (PowerPivot for SharePoint).

Application Management

Manage Service Applications

Use this page to create, configure, or modify the PowerPivot service applications used in the farm. For more information, see Create and Configure a PowerPivot Service Application.

Manage Web Applications

Use General Settings to increase the maximum upload size for the current web application if you are configuring a PowerPivot deployment manually.

Configure Service Application Associations

Use this page to add PowerPivot service to the default connection group or use it in a custom list. For more information, see Connect a PowerPivot Service Application to a SharePoint Web Application.

Specify the Default Database Server

Use this page to view information about server that is most likely hosting the PowerPivot service application databases.


Configure Diagnostic Logging

Use this page to specify which type of PowerPivot messages are captured in the Windows event log and trace logs. For more information, see Configure Event Logging (PowerPivot for SharePoint).

Usage Logging

Use this page to specify which PowerPivot events for which you want to collect usage data. For more information, see Configure Usage Data Collection (PowerPivot for SharePoint).

Check Job Status

Use this page to view history and status of jobs that target either the PowerPivot service or Analysis Services service instance.

Review Job Definitions

Use this page to view, change or delete the PowerPivot data refresh timer job used to trigger data refresh operations. For more information, see PowerPivot Data Refresh Overview.


Configure service accounts

Use this page to view or modify PowerPivot service accounts. For more information, see Change Service Accounts and Passwords (PowerPivot for SharePoint).

General Application Settings

PowerPivot Service

Use this page to open the PowerPivot Management Dashboard to monitor and analyze PowerPivot requests in the farm. For more information, see PowerPivot Management Dashboard.

PowerPivot for SharePoint adds a management dashboard to Central Administration so that you can monitor server health, PowerPivot query response times, PowerPivot data source metrics, and PowerPivot data refresh status. For more information, see PowerPivot Management Dashboard.

After PowerPivot for SharePoint is installed, application pages in team sites provide access to templates and operations:

Site or page


Site owners can add PowerPivot Gallery to their sites.

Document owners can use PowerPivot Gallery to share PowerPivot workbooks from a central location. PowerPivot offers rich preview and report creation support for PowerPivot workbooks that are not available in libraries. For more information, see Manage PowerPivot Gallery.

Site owners can add Data Feed Library to their sites.

Data specialists can use a Data Feed library to publish Atom data service documents that provide usable feeds for PowerPivot data import. For more information, see How to: Create or Customize a Data Feed Library.

Manage Data Refresh, command for Excel (.xlsx) workbooks in any library.

In a web application that supports PowerPivot requests, all Excel workbook (.xlsx) files have a Manage Data Refresh action that can be used to schedule data refresh for PowerPivot data in a workbook. For more information, see Schedule PowerPivot Data Refresh.

SharePoint 2010 infrastructure provides service and functionality to support distributed applications in the farm:

  • Auto-discovery of new shared service instances as you add them to the farm. New physical instances of a particular service are detected and used by Web applications that subscribe to that service.

  • Isolation at the application level. You can independently configure multiple shared services to isolate configuration settings and application data. If your deployment requires that individual SharePoint applications have no data stores in common, you can set up multiple shared services to ensure application and configuration data is kept separate.

  • Usage data collection for documents and data in the farm. SharePoint offers usage data collection. Logged events are routed to a central repository in a SharePoint farm. If you are already monitoring the SharePoint logs, you will see PowerPivot service messages in the logs. PowerPivot for SharePoint supplements standard usage data collection by adding built-in reports and longer term storage so that you can keep usage data for an extended period.

  • Monitoring server status and availability is provided in Central Administration. PowerPivot connections, load, unload, and query processing events are captured in the usage data collection system, and errors and warning are recorded in SharePoint trace logs.

  • Diagnostic tools and data are also part of farm administration.

  • SharePoint permissions determine access to data and operations. You can also set up workflows and manage PowerPivot workbooks using standard document management features in SharePoint.

Community Additions