Microsoft Power BI Report Server (PBRS) and SQL Server Reporting Services (SSRS) metadata and lineage
Overview
Power BI Report Server (PBRS) or SQL Server Reporting Services (SSRS) is an on premises business intelligence software that helps you see and understand your data. The PBRS and SSRS integration in Collibra is a harvester integration that consists of:
- Metadata ingestion in Data Catalog
- Automatic stitching
- Technical lineage
- Business summary lineage
PBRS and SSRS use the same APIs the export metadata. As such, all assets are ingested in Catalog as SSRS assets with the addition of Power BI reports in case of PBRS.
Important info: While SSRS and PBRS use the same API, we can access less information from PBRS reports than from SSRS data. As a result, we do not support stitching and lineage information for PBRS reports.
Media
More details
Release Notes
SSRS and PBRS were released via CLI harvester in 2022 and in Edge in 2024.
We highly recommend to use the latest lineage harvester or Edge 2024.05 or later.
Compatibility
- Power BI Report Server
- SQL Server Reporting Services
- Collibra Data Intelligence Cloud
Dependency
- Java Runtime Environment 11
License and Usage Requirements
Community
See existing Q&A in the Collibra Community
Browse discussions with customers who also use this app.
Start a New Topic in the Collibra Community
Collibra-hosted discussions will connect you to other customers who use this app.
Technical Support
Support and documentation is provided for all harvester integrations.
Create a support ticket.
Use of this integration requires the following licenses:
- Collibra Data Intelligence Cloud
- Data Catalog
- BI Integration.
Please contact your sales representative or Customer Success Manager for more information.
