SQL Server Reporting Services and Power BI Report Server operating model

The harvester collects SQL Server Reporting Services metadata and sends it to the Collibra Data Lineage server. Collibra processes the metadata and creates new SSRS assets and relations in Data Catalog. You can see them on the asset page overview or visualize them in a diagram or in a technical lineage.

Note 
  • The assets have the same names as their counterparts in SQL Server Reporting Services and Power BI Report Server. Full names and Names cannot be changed in Data Catalog.
  • Assets ingested from SQL Server Reporting Services and Power BI Report Server are called SSRS assets in Data Catalog, except for Power BI Report Server reports which are called Power BI Report assets.
  • Asset types are only created if you have all specific Data Catalog permissions.
  • All SQL Server Reporting Services and Power BI Report Server assets are created in the same domain.
  • Relations that were manually created between SSRS assets or Power BI Report assets and other assets via a relation type in the SQL Server Reporting Services and Power BI Report Server operating model, are deleted after synchronizing the metadata.

SQL Server Reporting Services and Power BI Report Server metadata overview

The following image shows the relations between SSRS asset types and the Power BI Report asset type.

Harvested metadata per asset type

This table shows the harvested SQL Server Reporting Services and Power BI Report Server metadata for each SSRS asset type and Power BI Report asset type, assuming you have the necessary subscriptions and configurations for a full ingestion.

Asset type Harvested SQL Server Reporting Services metadata in Data Catalog
SSRS Column
  • Full name
  • NameDisplay name
  • Description
  • Technical Data Type
  • BI Data Model contains / is part of BI Data Attribute
  • Data Element targets / sources Data Element
  • Data Entity contains / is part of Data Attribute
SSRS Data Model
  • Full name
  • NameDisplay name
  • Description
  • Certified
  • URL
  • Document creation date
  • Document modification date
  • Document size
  • Visible on server
  • Location
  • BI Data Model contains / is part of BI Data Attribute
  • Data Asset is source for / source BI report
  • BI Folder contains / contained in Data Asset
  • Data Entity is part of / contains Data Model

SSRS Folder
  • Full name
  • NameDisplay name
  • Description
  • URL
  • Document creation date
  • Document modification date
  • Visible on server
  • Location
  • BI Folder assembles / is assembled in BI Folder
  • Business Dimension groups / is grouped into Report
  • BI Folder contains / contained in Data Asset
  • Server hosts / is hosted in Business Dimension

SSRS KPI
  • Full name
  • NameDisplay name
  • Description
  • Certified
  • URL
  • Document creation date
  • Document modification date
  • Document size
  • Visible on server
  • Location
  • Report Attribute contained in / contains Report
  • Report related to / impacted by Business Asset
  • Data Asset is source for / source BI Report
  • Business Dimension groups / is grouped into Report
SSRS Parameter
  • Full name
  • NameDisplay name
  • Description
  • Report Attribute contained in / contains Report
  • Report Attribute sourced from / is source of Data Attribute
  • Business Asset represents / represented by Data Asset
SSRS Report
  • Full name
  • NameDisplay name
  • Description
  • Certified
  • URL
  • Document creation date
  • Document modification date
  • Document size
  • Visible on server
  • Location
  • Report uses / is used in Report
  • Data Asset is source for / source BI Report
  • Report related to / impacted by Business Asset
  • Business Dimension groups / is grouped into Report
Power BI Report
  • Full name
  • Name
  • Description
  • Certified
  • URL
  • Document creation date
  • Document modification date
  • Document size
  • Visible on server
  • Location
  • Business Dimension groups / is grouped into Report
  • Report related to / impacted by Business Asset
  • Report uses / is used in Report
  • Data Asset is source for / source BI Report
SSRS Server
  • Full name
  • NameDisplay name
  • Description
  • Server hosts / is hosted in Business Dimension
SSRS Table
  • Full name
  • Display name
  • Description
  • Data Entity contains / is part of Data Attribute
  • Data Entity is part of / contains Data Model

Example of ingested SQL Server Reporting Services and Power BI Report Server metadata

The following image shows an example structure after SQL Server Reporting Services and Power BI Report Server ingestion.