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

Remove-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).

Deletes a Power Pivot service application.

Applies To: SharePoint 2010 and SharePoint 2013.

Remove-PowerPivotServiceApplication [-Identity <SPGeminiServiceApplicationPipeBind>] [-DeleteAll <switch>] [-RemoveData <switch>] [-Confirm <switch>] [<CommonParameters>]

The Remove-PowerPivotServiceApplication cmdlet deletes a Power Pivot service application from the farm. Use DeleteAll to delete all service applications at once, or use the Identity parameter to remove a single instance. To get instance information, run Get-PowerPivotServiceApplication to return all instances in the farm.

Use the RemoveData parameter to optionally remove service application databases and cached files. Power Pivot workbooks remain in content libraries, but are no longer functional once the service application is removed.

-Identity <SPGeminiServiceApplicationPipeBind>

Specifies the GUID of a single Power Pivot service application in the farm. You must specify the GUID if you want to remove just one application, leaving other service applications intact.

Required?

false

Position?

0

Default value

Accept pipeline input?

true

Accept wildcard characters?

false

-Confirm <switch>

Prompts you for confirmation before executing the command. This value is enabled by default. To bypass the confirmation response in a command, specify Confirm:$false on the command.

Required?

false

Position?

named

Default value

Accept pipeline input?

false

Accept wildcard characters?

false

-DeleteAll <switch>

Deletes all Power Pivot service applications, but does not delete the service application database, nor the service instance objects in the farm. Power Pivot System Service and Power Pivot Engine Service objects remain instantiated, but unusable, after you remove the service applications.

Required?

false

Position?

named

Default value

Accept pipeline input?

false

Accept wildcard characters?

false

-RemoveData <switch>

Removes the service application database that contains data refresh schedules, workbooks usage data, instance maps used to track which databases are loaded, and other internal data.

Required?

false

Position?

named

Default value

Accept pipeline input?

false

Accept wildcard characters?

false

<CommonParameters>

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.

Inputs

None.

Outputs

None.

C:\PS>Remove-PowerPivotServiceApplication -identity 12345678-90ab-cdef-ghijklmnop

This example deletes a single Power Pivot service application, but does not remove its database or cache. If you do not specify an identity, you will be prompted to provide one.

C:\PS>Remove-PowerPivotServiceApplication -DeleteAll

This example deletes all Power Pivot service applications in the farm. Databases and cache are not deleted.

CC:\PS>Remove-PowerPivotServiceApplication -identity 12345678-90ab-cdef-ghijklmnop -RemoveData

This example deletes a single Power Pivot service application, and its database and cache files.

Community Additions

ADD
Show:
© 2015 Microsoft