Set-PowerPivotSystemService cmdlet

Sets the global properties of the PowerPivotSystemService object at the farm-level.

Syntax

Set-PowerPivotSystemService [-Identity <PowerPivotMidTierServicePipeBind>] [-UpdateAssemblyInformation <switch>] [-WorkbookUpgradeOnDataRefresh <boolean>] [-DirectTCPConnections <boolean>] [-Confirm <switch>] [<CommonParameters>]

Description

The Set-PowerPivotSystemService cmdlet updates the properties of the PowerPivot System Service parent object in the farm.

Parameters

-Identity <PowerPivotMidTierServicePipeBind>

Specifies the parent object for which you are updating properties. The value must be a valid GUID that uniquely identifies the object in the farm.

-UpdateAssemblyInformation <switch>

Used for upgrade purposes only. If the assembly version deployed in the farm is different from the version that is stored in the SharePoint configuration database, you can run this cmdlet to update the assembly information in the configuration database. Assembly version information is available in the file properties of the Microsoft.AnalysisServices.SharePoint.Integration.dll that is stored in the global assembly.

-WorkbookUpgradeOnDataRefresh <boolean>

Used to automatically upgrade a SQL Server 2008 R2 workbook at the start of a scheduled data refresh on the server. Data refresh is supported only for workbooks that match the current version of the server. If you enable this property, a workbook will be automatically upgraded so that data refresh can continue. This property is set at the server instance level. You cannot vary it for specific workbooks, libraries, sites, or users.

-DirectTCPConnections <boolean>

Specifies that Excel Services sends all queries directly to the instance of SQL Server Analysis Services (POWERPIVOT) that loaded a PowerPivot database, bypassing the MSOLAP data provider and channel transport that are otherwise used for every query request sent to a PowerPivot database.

Setting this parameter improves the performance and scalability of PowerPivot queries by making the connections to loaded databases more efficiently. Note that this parameter does not change the behavior of how the initial load request is allocated. Other parameters, such as –RoundRobinAllocation and –HealthBasedAllocation, that are used to allocate database load requests among multiple PowerPivot for SharePoint instance in the farm are unaffected because –DirectTCPConnections applies only to queries that are issued after the database is loaded.

For farm topologies that include Excel Services and PowerPivot for SharePoint running on separate application servers, you must open a port in the firewall to ensure that requests reach the SQL Server Analysis Services (POWERPIVOT) instance. For instructions on how to enable in-bound connections for a named instance of Analysis Services, see Configure the Windows Firewall to Allow Analysis Services Access.

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

<CommonParameters>

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.

Example 1

C:\PS>Set-PowerPivotSystemService -WorkbookUpgradeOnDataRefresh:$true

Enables automatic upgrade of previous version workbooks so that scheduled data refresh can proceed.