Working with SQL Server Reporting Services (SSRS) and Power BI Report Server (PBRS)

SQL Server Reporting Services and Power BI Report Server are server-based report generating applications created by Microsoft that helps you see and understand your data.

Power BI Report Server is included in the licensing of the SQL Server Enterprise Edition or as a free extension of Power BI premium. SQL Server Reporting Services and Power BI Report Server are closely related and both use the same API to communicate to the lineage harvester. As a result, Collibra created one operating model that contains data from both SQL Server Reporting Services and Power BI Report Server. Whether you use SQL Server Reporting Services, Power BI Report Server or both, you only need one integration in the lineage harvester configuration file.

Note While SQL Server Reporting Services and Power BI Report Server use the same API, we can access less information from Power BI Report Server reports than from SQL Server Reporting Services data. As a result, we do not support stitching and lineage information for Power BI Report Server reports.