| title | Reporting Services site collection features | |
|---|---|---|
| description | Learn about the SharePoint site collection features that SQL Server Reporting Services SharePoint mode provides. | |
| ms.date | 09/25/2024 | |
| ms.service | reporting-services | |
| ms.subservice | report-server-sharepoint | |
| ms.topic | concept-article | |
| ms.custom |
|
|
| monikerRange | >=sql-server-2016 <=sql-server-2016 |
[!INCLUDEssrs-appliesto] [!INCLUDEssrs-appliesto-2016] [!INCLUDEssrs-appliesto-sharepoint-2013-2016i] [!INCLUDEssrs-appliesto-not-pbirsi]
[!INCLUDE ssrs-previous-versions]
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.
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 [!INCLUDEmsCoName] [!INCLUDEssRSCurrent] 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 [!INCLUDEsql2008r2] 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 [!INCLUDEmsCoName] Reporting Services This feature is Active by default. |
| Power View Integration Feature | Enables interactive data exploration and visual presentation against [!INCLUDEpower-pivot-md] 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. |