SharePoint 2013 – Enable PowerPivot Features

2017-12-11T10:06:05+00:00 August 5th, 2014|Sharepoint|

Following on from my recent Create PowerPivot Service Application post, I actually have another minor gripe with the PowerPivot for SharePoint 2013 Configuration Tool; the limit of 20 Site Collections displayed on the “Activate PowerPivot Feature in a Site Collection” task.

PPFeatureGUI

In small environments, or Farms configured for legacy path-based Site Collections, this probably isn’t an issue. For larger environments, or Farms using host-named Site Collections, not having the ability to deploy these features through the GUI can be frustrating, but the answer is close to hand. I mentioned in my previous post, that you can simply click the “Script” tab to discover what the GUI is actually doing. However, the task to enable the PowerPivot feature on a Site Collection calls a function, called “EnableSiteFeatures”,  in the PowerPivot resources directory:

  • [Drive]:Program FilesMicrosoft SQL Server110ToolsPowerPivotToolsSPAddinConfigurationResourcesConfigurePowerPivot.ps1

If you can’t be bothered, or don’t have time to look for yourself, the function is basically performing the following actions (just swap out the $url variable to suit your target Site Collection):

$url = "http://yoursitecollection.fqdn";
Enable-SPFeature -Identity "PowerPivotSite" -URL $url -Force;
Enable-SPFeature -Identity "8581A8A7-CF16-4770-AC54-260265DDB0B2" -URL $url -Force;