Activate the report server and Power View integration features in SharePoint

Applies to: ✅ SQL Server Reporting Services (2016) ✅ SharePoint ❌ Power BI Report Server

For content related to previous versions of SQL Server Reporting Services (SSRS), see SQL Server 2014 Reporting Services.

The Reporting Services site collection features are activated by default after you install the Microsoft SQL Server 2016 (13.x) Reporting Services or later (SSRS) Add-in for SharePoint products. In some situations, you need to manually activate the features.

Note

Reporting Services integration with SharePoint is no longer available after SQL Server 2016. Power View support is no longer available after SQL Server 2017.

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 are only activated for root site collections. For other site collections, you need to manually activate the features. For example, if you have a site collection of https://[my server name]/sites/[site collection name] you need to manually activate the Reporting Services site collection features.

When there's no root site collection, the Reporting Services add-in logs a message similar to the following.

"SharePoint web app 80 doesn't have root site collection"

The message is found in the add-in installation log, named "RS_SP_#.log" where # is an incrementing number. The log file is 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.

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. Select Site Actions.

  3. Select Site Settings.

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

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

  6. Select Activate.

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

Activate or Deactivate Reporting Services central administration site collection feature

  1. Open your browser to SharePoint Central Administration.

  2. Select Site Actions.

  3. Select Site Settings.

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

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

  6. Select Activate.

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

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

More questions? Try asking the Reporting Services forum