SQL Server Reporting Services

SSRS 2016, and later versions as well as the Power BI Report Server, supports integration with the Power BI service. Once integration has been configured between the on-premises report server and the Power BI tenant, certain SSRS report items, such as charts and maps, can be pinned to Power BI dashboards. Additionally, a reporting services subscription is automatically created for pinned report items, allowing for report server administrators to manage the data refresh schedule of the dashboard tile.

In the following image of the Report Server Configuration Manager, a Power BI Report Server has been configured:

Power BI integration with Power BI Report Server

In the preceding image, the Power BI Report Server ...

Get Mastering Microsoft Power BI now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.