Developing Business Intelligence Apps for SharePoint

Chapter 36. PowerPivot Instance Configuration

Configuring PowerPivot version 1 was a significant task that caused many of us to lose large amounts of hair, sleep, and sanity. Happily, PowerPivot version 2 has made amends for these transgressions and provides us with two primary methods for configuration: PowerShell and a wizard-driven experience. Even the most seasoned veteran of the PowerShell gurus among us acknowledge the beauty of this wizard-driven experience partly because it provides us with the exact PowerShell code that it will run for us. We get the opportunity to utilize the wizard to write this code rather than trying to come up with it on our own.

The requirements for running the PowerPivot configuration are:

• The computer must have PowerPivot for SharePoint installed according to the guidance given in Chapter 35.

• The SharePoint server hosting the PowerPivot service application must be running SharePoint 2010 SP1 with the August 2010 (or later) cumulative update installed.

• The account performing the upgrade must be a farm administrator, have db_owner permissions on the Analysis Services instance, and be a local administrator to execute the upgrade of a PowerPivot for SharePoint installation.

• You must have domain user accounts for all services that will be provisioned during configuration.

  • You can start with using a single default account, and then change the service accounts later using Central Administration.

• There must be at least one SharePoint web application running under ...