Edit

Activate the report server and Power View integration features in SharePoint

  • Article

Applies to: SQL Server Reporting Services (2016) SharePoint Not supported 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 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 will only be 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 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 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. 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.

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.

More questions? Try asking the Reporting Services forum