This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to: 
SQL Server Reporting Services (2016) ❌ SQL Server Reporting Services (2017)
SharePoint ❌ Power BI Report Server
For content related to previous versions of SQL Server Reporting Services (SSRS), see What is SQL Server Reporting Services?
SQL Server Reporting Services in SharePoint, enables report creation and viewing in document libraries, Reporting Services subscription delivery of reports through email, Power View, data alerting, and report management features, all in a deployment of based of Microsoft SharePoint. For more information regarding features in SharePoint mode, see the section "Feature Support and Behavior Differences by Server Mode" in Reporting Services Report Server.
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.
There are two core Reporting Services components to install for Reporting Services in SharePoint mode:
| Installation | Description |
|---|---|
| Report Server: The Microsoft SQL Server Reporting Services report server installed in SharePoint Mode | The report server handles the data and report processing and rendering as well subscription and Data Alert processing. The SharePoint mode report server is designed and installed as a SharePoint Shared Service. How: Use the SQL Server installation media to install the report server. |
| Add-in: The Microsoft SQL Server Reporting Services add-in for SharePoint products, rssharepoint.msi. | The add-in installs the Reporting Services user interface (UI) pages and features on a SharePoint web front-end server. The UI features include Power View, administration pages in SharePoint Central Administration, feature pages used within SharePoint document libraries, and Reporting Services Data Alerting pages. How: The add-in can be installed from either a Web download or the SQL Server installation media. For more information, see Where to find the Reporting Services add-in for SharePoint Products. |
Supported Combinations of SharePoint and Reporting Services Server and Add-in (SQL Server 2016)
Where to find the Reporting Services add-in for SharePoint Products
Install The First Report Server in SharePoint Mode
Install or Uninstall the Reporting Services Add-in for SharePoint
Add an Additional Report Server to a Farm (SSRS Scale-out)
Add an Additional Reporting Services Web Front-end to a Farm
Configure E-mail for a Reporting Services Service Application (SharePoint 2013 and SharePoint 2016)
Provision Subscriptions and Alerts for SSRS Service Applications
Claims to Windows Token Service (c2WTS) and Reporting Services
Training
Module
Integrate Power BI in Microsoft Teams and SharePoint - Training
This module explores the different ways users can incorporate Power BI reports or visuals into Microsoft Teams and SharePoint to collaborate with others. This functionality allows users to pair analytics with collaboration tools they are already familiar with.
Documentation
Reporting Services Report Server (SharePoint Mode) - SQL Server Reporting Services (SSRS)
A Reporting Services report server with SharePoint Mode can run in SharePoint to use collaboration and management features for Reporting Services content types.
Learn about the central piece of a SQL Server Reporting Services installation, which consists of a processing engine and extensions to add functionality.
What's new in SQL Server Reporting Services (SSRS) - SQL Server Reporting Services (SSRS)
Learn about what's new in the different versions of SQL Server Reporting Services (SSRS), including changes to the major feature areas.