Skip to main content

About the Power BI Report Server collector

Important

This collector is available in Private Preview. If you would like access to this collector, please contact your Customer Success Director.

The Power BI Report Server (PBIRS) collector is designed to provide you with an effective solution for extracting metadata from your PBIRS environment into the data.world catalog. The integration facilitates the automated extraction, organization, and presentation of specific metadata elements from the PBIRS system. It gives valuable insights into your datasets, data sources, folders, KPIs, reports, and linked reports – all within the data catalog in data.world.

With the PBIRS collector, you can:

  • Learn more about your Power BI reports and data, including who created a report or dataset and when they were last updated, helping you understand and trust your data.

  • See the lineage of which datasets were used in a report, allowing you a comprehensive view of the data flowing into a report.

  • Keep track of KPIs from PBIRS and integrate them with business metrics from other source systems, all within one easy-to-use catalog, leading to better data-informed decisions.

An example of metadata from a PBIRS Report, including Lineage:

powerbi-metadata-pbirs-report-lineage.png

Note

The latest version of the Collector is 2.243. To view the release notes for this version and all previous versions, please go here.

What is cataloged

The collector catalogs the following information.

Table 1.

Object

Information cataloged

Report 

ID, Name, Description, Creation Time, Modified Time, Created By, Modified By, Path, Type, Hidden, Size, Data Sources, Favorite, Content Type, Policies.

Linked Report 

ID, Name, Description, Creation Time, Modified Time, Created By, Modified By, Path, Type, Hidden, Size, Content Type, Policies.

Datasource 

ID, Name, Description, Creation Time, Modified Time, Created By, Modified By, Path, Type, Hidden, Size, Parent Folder ID, Connection String, Connection String Overridden, Data Source Type, Credential Retrieval, Content Type, Enabled, Original Connection String Expression Based, Policies.

Note: if the Name is not defined, then the Power BI Report Server identifier (GUID) for the data source is used as the name.

Dataset 

ID, Name, Description, Creation Time, Modified Time, Created By, Modified By, Path, Type, Hidden, Size, Policies.

KPI 

ID, Name, Description, Creation Time, Modified Time, Created By, Modified By, Path, Type, Hidden, Size, Content Type, Currency, Value Format, Visualization, Content Type, Policies.

Folder 

ID, Name, Description, Creation Time, Modified Time, Created By, Modified By, Path, Type, Hidden, Size, Content Type, Policies.

Power BI Report 

ID, Name, Description, Creation Time, Modified Time, Created By, Modified By, Path, Type, Hidden, Size, Data Sources, Content Type, Policies.

Excel Workbook 

ID, Name, Description, Creation Time, Modified Time, Created By, Modified By, Path, Type, Hidden, Size, Content Type, Policies.



Relationships between objects

By default, the harvested metadata includes catalog pages for the following resource types. Each catalog page has a relationship to the other related resource types. If the metadata presentation for this data source has been customized with the help of the data.world solutions team, you may see other resource pages and relationships.

Table 2.

Resource page

Relationship

Report 

  • Integrated Data Source contained within the Report

  • Referenced Datasets contained within the Report

  • Integrated Datasets contained within the Report

Linked Report 

  • The Report that the Linked Report links to

Dataset 

  • Referenced Data Source embedded within the Dataset

KPI 

  • Dataset referenced by KPI

  • Data source associated with the KPI Report

Datasource 

  • Dataset that contain a Data Source

Folder 

  • Power BI Report Server Resources (KPI, Datasets, Data Sources, Reports, Linked Report) Contained in Folder

  • Sub-folders contained within the Folder



Lineage for Power BI Report Server

Table 3.

Object

Lineage Available

Dataset 

  • Data Source that the dataset sources its data from

  • Reports that use its data from the dataset

Datasource 

  • Datasets that sources data from this data source

  • Reports that use data from this data source

Report 

  • Datasets from which this report sources data

  • Data sources from which this report sources data

Power BI Report 

  • Data sources from which this report sources data



Authentication supported