Activate the Report Server and Power View Integration Features in SharePoint

The site collection features are usually activated by default after you install the Microsoft SQL Server 2012 Reporting Services (SSRS) Add-in for SharePoint products. In some situations you will need to manually activate the features.

If you install the Reporting Services add-in for SharePoint 2010 Products after the installation of the SharePoint product, then the Report Server integration feature and the Power View integration feature will only be activated for root site collections. For other site collections, you will need to manually activate the features. For example if you have a site collection of http://[my server name]/sites/[site collection name] you will need to manually activate the Reporting Services site collection features.

When there is no root site collection, the Reporting Services add-in will log a message similar to the following.

"SharePoint web app 80 does not have root site collection"

The message will be found in the add-in installation log, named “RS_SP_#.log” where # is an incrementing number. The log file will be found in the current users Temp folder, for example C:\Users\[user name]\AppData\Local\Temp. For more information on logging options with the add-in, see Install or Uninstall the Reporting Services Add-in for SharePoint.

In this topic:

  • Activate the Report Sever and Power View Integration Features

  • Activate the Report Server Central Administration Feature

Important

If the Reporting Services integration feature does not appear under Site Collection Features, on the SharePoint site, confirm that the Reporting Services Central Administration Site Collection feature is active. For more information about the role of the Reporting Services integration feature, see Add Report Server Content Types to a Library (Reporting Services in SharePoint Integrated Mode).

To Activate the Report Server and Power View Integration Site Collection Features:

  1. Open your browser to the site where you want the Reporting Services features active.

  2. Click Site Actions.

  3. Click Site Settings.

  4. Click Site Collection Features in the Site Collection Administration Group.

  5. Find Report Server Integration Feature or Power View Integration Feature in the list.

  6. Click Activate.

To deactivate the features, you can use the same procedure, but click Deactivate rather than Activate.

To Activate or Deactivate Reporting Services Central Administration Site Collection Feature:

  1. Open your browser to SharePoint Central Administration.

  2. Click Site Actions.

  3. Click Site Settings.

  4. Click Site Collection Features in the Site Collection Administration Group.

  5. Find Report Server Central Administration Feature in the list.

  6. Click Activate.

To deactivate the feature, you can use the same procedure, but click Deactivate rather than Activate.

Next Steps

After the feature is activated, you can continue with server integration.

See Also

Concepts

Install or Uninstall the Reporting Services Add-in for SharePoint

Other Resources

Quiz: Configuring SSRS 2012 for SharePoint Integration