Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Get-PowerPivotEngineServiceInstance cmdlet

Get-PowerPivotEngineServiceInstance 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 instances of SQL Server Analysis Services running on application servers in the farm.

Applies to: SharePoint 2010.

Get-PowerPivotEngineServiceInstance [-Identity <PowerPivotEngineServiceInstancePipeBind>] [<CommonParameters>]

The Get-PowerPivotEngineServiceInstance cmdlet returns the properties of one or more SQL Server Analysis Services (Power Pivot) instances running in the farm. The cmdlet reports the application type, status (online or offline), and the identity. To view additional properties of a specific instance, add the Identity parameter and the format-list option to the cmdlet.

-Identity <PowerPivotEngineServiceInstancePipeBind>

Specifies the service instance 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.





C:\PS>Get-PowerPivotEngineServiceInstance -Identity 1234567-890a-bcde-fghijklm | format-list

This example returns additional properties of the specified instance, including the server name, version, configuration properties, and upgrade status.

Community Additions

© 2015 Microsoft