PowerShell Reference for Power Pivot for SharePoint

APPLIES TO:yesSQL Server Analysis ServicesnoAzure Analysis Services

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

Note

This article may contain outdated information and examples. Use the Get-Help cmdlet for the latest.

Cmdlet List

To see a list of cmdlets from the PowerShell prompt:

  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 SharePoint 2013 | SharePoint 2016
Get-PowerPivotSystemService cmdlet SharePoint 2013 | SharePoint 2016
Get-PowerPivotSystemServiceInstance cmdlet SharePoint 2013 | SharePoint 2016
New-PowerPivotServiceApplication cmdlet SharePoint 2013 | SharePoint 2016
New-PowerPivotSystemServiceInstance cmdlet SharePoint 2013 | SharePoint 2016
Remove-PowerPivotServiceApplication cmdlet SharePoint 2013 | SharePoint 2016
Remove-PowerPivotSystemServiceInstance cmdlet SharePoint 2013 | SharePoint 2016
Set-PowerPivotServiceApplication cmdlet SharePoint 2013 | SharePoint 2016
Set-PowerPivotSystemService cmdlet SharePoint 2013 | SharePoint 2016
Update-PowerPivotSystemService cmdlet SharePoint 2013 | SharePoint 2016

Note: The following Cmdlets only worked with SharePoint 2010, which SQL Server 2016 does not support.

  • Get-PowerPivotEngineService

  • Get-PowerPivotEngineServiceInstance

  • New-PowerPivotEngineServiceInstance

  • Remove-PowerPivotEngineServiceInstance

  • Set-PowerPivotEngineService

  • Set-PowerPivotEngineServiceInstance

  • Update-PowerPivotEngineService