TechNet
Export (0) Print
Expand All

PowerShell Reference for Power Pivot for SharePoint

 

Updated: November 16, 2015

Applies To: SQL Server 2016

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.

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*

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

Community Additions

ADD
Show:
© 2016 Microsoft