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