Export (0) Print
Expand All

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:

  1. Open SharePoint Management Shell using the Run as Administrator option.

  2. Enter the following command: Get-help *powerpivot*

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft