Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

PowerPivot Reference for SharePoint PowerShell

SQL Server 2012

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*

Community Additions

ADD
Show:
© 2015 Microsoft