Activate Power Pivot Feature Integration for Site Collections in Central Administration
Applies To: SQL Server 2016
Activating Power Pivot feature integration for specific site collections is required if you used the Existing Farm installation option to install SQL Server Power Pivot for SharePoint. If you installed Power Pivot for SharePoint using the New Server option, you can skip this task because SQL Server Setup already activated Power Pivot feature integration for the root site collection when it configured your deployment.
Feature activation at the site collection level is necessary to make application pages and templates available to your sites, including configuration pages for scheduled data refresh and application pages for Power Pivot Gallery and Data Feed libraries.
You must activate Power Pivot integration for each site collection that supports Power Pivot query processing.
You must be a site collection administrator.
On a SharePoint site, click Site Actions.
By default, SharePoint web applications are accessed through port 80. This means that you can often access a SharePoint site by entering http://<computer name> to open the root site collection.
Click Site Settings.
In Site Collection Administration, click Site collection features.
Scroll down the page until you find Power Pivot Integration Site Collection Feature.
Repeat for additional site collections by opening each site and clicking Site Actions.