Update-PowerPivotEngineService cmdlet

Update-PowerPivotEngineService cmdlet

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Upgrades the parent object of SQL Server Analysis Services in the farm.

Applies to: SharePoint 2010.

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

The Update-PowerPivotEngineService cmdlet runs a series of upgrade actions on the SQL Server Analysis Services parent object and instances in the farm. All of the Analysis Services instances in a Power Pivot 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 Power Pivot for SharePoint or if you have applied a cumulative update on the server. To check whether upgrade is required, run Get-PowerPivotEngineService to review the NeedsUpgrade property. If NeedsUpgrade is true, you should run the cmdlet to upgrade the server objects in the farm.

Because a Power Pivot for SharePoint deployment includes middle-tier and backend data services, you must run Update-PowerPivotSystemService whenever you run Update-PowerPivotEngineService 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 Power Pivot from your SharePoint farm and reinstall the software. To verify the upgrade operation succeeded, run Get-PowerPivotEngineService to review the global properties for version information and to verify that NeedsUpgrade is no longer set to true.

-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.





Default value

Accept pipeline input?


Accept wildcard characters?



This cmdlet supports the common parameters:

  • Verbose

  • Debug

  • ErrorAction

  • ErrorVariable

  • WarningAction

  • WarningVariable

  • OutBuffer

  • OutVariable

For more information, see About_CommonParameters.

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.





Community Additions

© 2015 Microsoft