Update-PowerPivotSystemService cmdlet

Upgrades the parent object of the PowerPivot System Service in the farm.

Applies To: SQL Server 2012 and SQL Server 2012 SP1

Syntax

Update-PowerPivotSystemService [-Confirm <switch>] [<CommonParameters>]

Description

The Update-PowerPivotSystemService cmdlet runs a series of upgrade actions on the PowerPivot System Service parent object, instances, and PowerPivot service applications in the farm. All of the middle-tier services and applications in a PowerPivot for SharePoint deployment must run at the same functional level. This cmdlet runs the upgrade actions on all of these objects.

Run this cmdlet after you have run SQL Server Setup to install a newer version of PowerPivot for SharePoint or if you have applied a cumulative update on the server. To check whether upgrade is required, run Get-PowerPivotSystemService to review the NeedsUpgrade property. If NeedsUpgrade is true, you should run the cmdlet to upgrade the PowerPivot middle-tier objects in the farm.

Because a PowerPivot for SharePoint deployment includes middle-tier and backend data services, you must run Update-PowerPivotEngineService whenever you run Update-PowerPivotSystemService to ensure that both tiers are the same version across the farm.

Upgrade cannot be rolled back to the previous version. If you must revert to a previous version, remove PowerPivot from your SharePoint farm and reinstall the software. To verify the upgrade operation succeeded, run Get-PowerPivotSystemService to review the global properties for version information and to verify that NeedsUpgrade is no longer set to true.

Parameters

-Confirm <switch>

Prompts you for confirmation before executing the command. This value is enabled by default. To bypass the confirmation response in a command, specify Confirm:$false on the command.

<CommonParameters>

This cmdlet supports the following parameters:

• Verbose

• Debug

• ErrorAction

• ErrorVariable

• WarningAction

• WarningVariable

• OutBuffer

• OutVariable

For more information, see About_CommonParameters.

Inputs and Outputs

The input type is the type of the objects that you can pipe to the cmdlet. The return type is the type of the objects that the cmdlet returns.