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.
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:
-
Open SharePoint Management Shell using the Run as Administrator option.
-
Enter the following command: Get-help *powerpivot*
|
Cmdlet |
Supported Versions |
|---|---|
|
2012 and 2012 SP1 |
|
|
2012 and 2012 SP1 |
|
|
2012 and 2012 SP1 |
|
|
2012 and 2012 SP1 |
|
|
2012 and 2012 SP1 |
|
|
2012 and 2012 SP1 |
|
|
2012 and 2012 SP1 |
|
|
2012 and 2012 SP1 |
|
|
2012 and 2012 SP1 |
|
|
2012 and 2012 SP1 |
|
|
2012 |
|
|
2012 |
|
|
2012 |
|
|
2012 |
|
|
2012 |
|
|
2012 |
|
|
2012 |
