TechNet
Export (0) Print
Expand All

Remove-PowerPivotServiceApplication cmdlet

 

Applies To: SQL Server 2016

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.

InputsNone.
OutputsNone.
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:
© 2016 Microsoft