Skip to main content

About the Power BI Gov collector

Use this collector to harvest metadata from Power BI Gov. Users can then:

  • Discover Power BI reports and dashboards across your enterprise’s Power BI workspaces.

  • Perform impact analysis to understand how changes to upstream data sources impact Power BI reports.

Important

The Power BI Gov collector can be run in the Cloud or on-premise using Docker or Jar files.

Note

The latest version of the Collector is 2.220. 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 collected

Workspaces

Title, Description

Power BI Measures

Title, Description, Is hidden, Expression

Reports

Title, External URL, Embed URL, Report type

Report Pages

Title

Dashboards

Title, External URL, Embed URL

Dashboard tiles

Title, Embed URL

Data Sources

Title, Data source type

Datasets

Title, External URL, Description

Dataflows

Title, Last modified, Description

Power BI Tables (Datasets and Dataflows)

Title, Is hidden, Description

Power BI Columns

Title, Data type, Column type, Is hidden, Expression

Tabular file

File path, File name

File directory

Directory path

Database

Title, Type, Identifier, Server, Port

Database Schema

Title

Database Table

Title

Database Column

Title, Type

Table

Title, Description

Column

Title, Type



Relationships between objects

By default, the data.world catalog will include catalog pages for the resource types below. Each catalog page will have a relationship to other related resource types. Note that the catalog presentation and relationships are fully configurable, so these will list the default configuration.

Table 2.

Resource page

Relationship

Power BI Column

Power BI Table

Data source

Dataset, Dataflow, , Connection Details (kind and path), Tabular Data source (Database, Tabular File)

Tile

Dashboard, Report, Dataset

Dashboard

Tile, Workspace

Report

Tile, Workspace, Report pages

Report Pages

Report

Dataset

Tile, workspace, report, table, data source, Dataset

Workspace

Report, Dataset, Dataflow, Dashboard

Dataflow

Workspace, Table, Data source, Dataflow

Power BI Table

Dataset, Dataflow, Power BI Column, Power BI Measure

Power BI Measure

Power BI Table

Tabular Data source (Database, Tabular File)

Data source



Lineage for Power BI Gov

The following lineage information is collected by the Power BI Gov collector.

Table 3.

Object

Lineage available

Report

Associated Dataset

Dashboard Tile

Associated Dataset

Dataset

Associated Dataflow, Dashboard Tile, Report, and Dataset

Dataflow

Associated Column, Dataset, and Dataflow

Note: The collector is able to harvest lineage from Power BI expressions which use parameters in place of database server name, schema name, database table, or database name.

Column

Associated columns that the column sources its data from or calculates its values from

Notes:

  • The collector is able to harvest lineage from Power BI expressions which use parameters in place of database server name, schema name, database table, or database name.

  • Table-level lineage, column-level lineage, and catalog relationships are not available between tables/columns (fields) and reports/report pages through the Power BI API.

Power BI Measure

Associated columns that the measure sources it data from.



Version supported

Authentication types supported

  • Authenticate to Power BI Gov using Service principal.