APPLIES TO:
SQL Server Analysis Services
Azure 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:
Open SharePoint Management Shell using the Run as Administrator option.
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

