Get-PowerPivotSystemService cmdlet

Get-PowerPivotSystemService cmdlet

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Returns the global properties of the Power Pivot System Service object in a farm.

Applies To: SharePoint 2010 and SharePoint 2013.

Get-PowerPivotSystemService [-Identity <PowerPivotMidTierServicePipeBind>] [<CommonParameters>]

The Get-PowerPivotSystemService cmdlet returns the global properties of the Power Pivot System Service object. There is one parent object per farm, but each farm can have multiple instances of the Power Pivot System Service that run on individual application servers in the farm. The parent object shows farm-level settings that do not vary by instance. If the farm includes multiple Power Pivot for SharePoint installations, a comma-delimited list of the instances will indicate how many Power Pivot System Service instances are in the farm.

-Identity <PowerPivotMidTierServicePipeBind>

Specifies the parent object to get. The value must be a valid GUID that uniquely identifies the object in the farm.





Default value

Accept pipeline input?


Accept wildcard characters?



This cmdlet supports the common parameters: Verbose, Debug, ErrorAction, ErrorVariable, WarningAction, WarningVariable,OutBuffer and OutVariable. For more information, see About_CommonParameters.

The input type is the type of the objects that you can pipe to the cmdlet. The return type is the type of the objects that the cmdlet returns.






This example returns the global properties of the parent object, showing properties that are shared by all instances of Power Pivot System Service in the farm.

Community Additions

© 2016 Microsoft