Activate Power Pivot Integration for Site Collections in CA

APPLIES TO:yesSQL Server Analysis ServicesnoAzure Analysis Services

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.

Activate Power Pivot Features

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

  2. Click Site Settings.

  3. In Site Collection Administration, click Site collection features.

  4. Scroll down the page until you find Power Pivot Integration Site Collection Feature.

  5. Click Activate.

  6. Repeat for additional site collections by opening each site and clicking Site Actions.

See Also

Power Pivot Server Administration and Configuration in Central Administration
Initial Configuration (Power Pivot for SharePoint)
Power Pivot for SharePoint 2010 Installation