PowerPivot Reference for SharePoint PowerShell

This section lists the PowerShell cmdlets used to configure or administer a PowerPivot for SharePoint installation. For more information about enabling the cmdlets and viewing built-in help, see Use Windows PowerShell to Configure PowerPivot.

Cmdlet List

The number of cmdlets available depends on the version of Analysis Services you are using.

• 10 cmdlets with SQL Server 2012 SP1 Analysis Services server running in SharePoint mode, and SharePoint 2013. The 2012 SP1 version utilizes a new architecture that allows the Analysis Server to run outside the SharePoint farm and requires fewer management PowerShell cmdlets.

• 17 cmdlets with SQL Server 2012 Analysis Services server running in SharePoint mode, and SharePoint 2010.

To see a list of cmdlets:

1. Open SharePoint Management Shell using the Run as Administrator option.

2. Enter the following command: Get-help *powerpivot*

Cmdlet	Supported Versions
Get-PowerPivotServiceApplication cmdlet	2012 and 2012 SP1
Get-PowerPivotSystemService cmdlet	2012 and 2012 SP1
Get-PowerPivotSystemServiceInstance cmdlet	2012 and 2012 SP1
New-PowerPivotServiceApplication cmdlet	2012 and 2012 SP1
New-PowerPivotSystemServiceInstance cmdlet	2012 and 2012 SP1
Remove-PowerPivotServiceApplication cmdlet	2012 and 2012 SP1
Remove-PowerPivotSystemServiceInstance cmdlet	2012 and 2012 SP1
Set-PowerPivotServiceApplication cmdlet	2012 and 2012 SP1
Set-PowerPivotSystemService cmdlet	2012 and 2012 SP1
Update-PowerPivotSystemService cmdlet	2012 and 2012 SP1
Get-PowerPivotEngineService cmdlet	2012
Get-PowerPivotEngineServiceInstance cmdlet	2012
New-PowerPivotEngineServiceInstance cmdlet	2012
Remove-PowerPivotEngineServiceInstance cmdlet	2012
Set-PowerPivotEngineService cmdlet	2012
Set-PowerPivotEngineServiceInstance cmdlet	2012
Update-PowerPivotEngineService cmdlet	2012