Report Viewer web part on a SharePoint site - Reporting Services
Applies to: ✅ SQL Server 2016 (13.x) Reporting Services and later ✅ Power BI Report Server ✅ SharePoint 2016 and later ❌ SharePoint Online
The Report Viewer web part is a custom web part. You can use the web part to view, navigate, print, and export reports on a report server within a SharePoint site. The Report Viewer web part is associated with report definition (.rdl) files that a Microsoft SQL Server Reporting Services report server processes.
The latest Report Viewer web part can also service paginated reports deployed to Power BI Report Server. The web part doesn't work with Power BI reports.
Why the Report Viewer web part is reintroduced
The Report Viewer web part was available as part of the Reporting Services Add-in for SharePoint products. The web part was specific for report servers in SharePoint integrated mode. SharePoint integrated mode was deprecated after SQL Server 2016.
Starting with SQL Server 2017, there's only one installation mode for Reporting Services: Native mode. You could embed all reports types using a Page Viewer web part using the rs:Embed=true URL parameter. Embedding reports into SharePoint pages is an integration story requested by customers and the updated Report Viewer web part enables this scenario for paginated reports.
While the Page Viewer web part suffices to embed a paginated report into a SharePoint page, the updated Report Viewer web part offers more features.
- Show/hide specific toolbar buttons
- Override report parameter values
- Connect Filter web parts to report parameters
Download the Report Viewer web part solution package
The Report Viewer web part is available on the Microsoft Download Center.
Considerations and limitations
The items listed are specific to the updated Report Viewer web part.
- The web part can only be used on classic SharePoint pages.
- Only paginated (RDL) reports are supported for embedding in the Report Viewer web part. If you're looking to embed Power BI reports or mobile reports, you can use the rs:Embed=true URL parameter.
To get started with the updated Report Viewer web part, see Deploy the Report Viewer web part on a SharePoint site.