Share via


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 PowerPivot Configuration using Windows PowerShell.

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