Get-PowerPivotServiceApplication cmdlet

APPLIES TO:yesSQL Server Analysis ServicesnoAzure Analysis Services

Returns one or more Power Pivot service applications.


This article may contain outdated information and examples. Use the Get-Help cmdlet for the latest.

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.

Required? false
Position? 0
Default value
Accept pipeline input? true
Accept wildcard characters? false


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

Inputs and Outputs

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.

Inputs None.
Outputs None.

Example 1


This example returns one or more service applications in the farm.

Example 2

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

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

Example 3

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.