Reporting Services site collection features

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.

Reporting Services SharePoint mode provides three SharePoint site collection features. The features support the general Reporting Services SharePoint mode reporting environment, Power View, a feature of the SQL Server 2016 Reporting Services Add-in, and management operations for Reporting Services in SharePoint Central Administration.

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.

Site collection features

The following table describes the Reporting Services site collection features.

Feature Description
Report Server Central Administration Feature Enables Features for managing integration with a Reporting Services report server. This feature is only installed and used in the SharePoint Central Administration site collection.

The Report server integration feature is automatically activated in SharePoint Central Administration Site collection 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 feature. To activate the report server feature, use the Reporting Services pages in SharePoint Central Administration's Site Settings page.

The SQL Server 2008 R2 (10.50.x) Reporting Services version and later of the Add-in for SharePoint products activate the report server integration feature for all existing site collections when the Add-in is installed. Additionally, the feature is automatically active for new site collections.
Report Server Integration Feature Enables rich reporting using Microsoft Reporting Services

This feature is Active by default.
Power View Integration Feature Enables interactive data exploration and visual presentation against Power Pivot work books and Analysis services tabular databases.

The feature can be accessed by the context menus of the following data sources:

.rdlx

.rsds

.bism connection file



If Power View doesn't appear in the context menus, verify the Power View Integration Feature is activated.

This feature is deactivated by default.

Activate the report server and Power View integration features in SharePoint
Reporting Services site settings and site features(SharePoint Mode)
Activate the report server file sync feature in SharePoint Central Administration

More questions? Try asking the Reporting Services forum