Get-PowerPivotServiceApplication cmdlet

Get-PowerPivotServiceApplication 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 one or more Power Pivot service applications.

Applies To: SharePoint 2010 and SharePoint 2013.

Get-PowerPivotServiceApplication [[-Identity] <SPGeminiServiceApplicationPipeBind>] [<CommonParameters>]

The Get-PowerPivotServiceApplication cmdlet returns the service application specified by the Identity parameter. If no parameter is specified, the cmdlet returns all Power Pivot service applications in the farm. Each application is identified by its display name, application type, and GUID. To view additional properties of a Power Pivot service application, add the format-list option to the cmdlet.

-Identity <SPGeminiServiceApplicationPipeBind>

Specifies the service application 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 one or more service applications in the farm.

C:\PS>Get-PowerPivotServiceApplication | format-list

This example returns all of the properties of a Power Pivot service application.

C:\PS>get-PowerPivotServiceApplication -Identity 1234567-890a-bcde-fghijklm

This example returns a single service application, showing the display name, application type, and GUID of the application. If the display name is long, it will be truncated. Use the format-list option to view the full name.

Community Additions

© 2016 Microsoft