Share via

  • Article

Configuration (PowerPivot for SharePoint)

PowerPivot for SharePoint must be configured before it can be used. SQL Server Setup will configure the PowerPivot server components automatically if you chose the New Server installation option. However, if you used the Existing Farm installation option, you must configure the server after SQL Server Setup installs the software. At a minimum, you must perform all three of the required configuration tasks in the list below.

In this section

Required Tasks for an Existing Farm Installation

Deploy PowerPivot Solutions

Create and Configure a PowerPivot Service Application

Activate PowerPivot Feature Integration for Site Collections

Configure Usage Data Collection (PowerPivot for SharePoint)

Enable and Configure PowerPivot Data Refresh

Configure and Use the PowerPivot Unattended Data Refresh Account

Configure and Use Stored Credentials for PowerPivot Data Refresh

Optional or As-Needed Tasks

Configure Dedicated Data Refresh or Query-Only Processing

Change Service Accounts and Passwords (PowerPivot for SharePoint)

Connect a PowerPivot Service Application to a SharePoint Web Application

Create a trusted location for PowerPivot sites

Configure Event Logging (PowerPivot for SharePoint)

PowerShell Configuration Script (PowerPivot for SharePoint)

Configuration Quick Reference (PowerPivot for SharePoint)