Power BI Integration Discovered Resources

Ingested Resources & Properties

Workspaces (powerbi_workspace)

Property	Description
name	Display name of the workspace
owner	Owner/creator (when available)
created_at	Timestamp for creation date
updated_at	Timestamp last modification
external_link	URL to open the workspace in the service
is_enabled	Whether the workspace is active/ingestible
tags	User-defined tags
labels	System or user labels for categorization (sensitivity and endorsements labels)

Semantic Models (powerbi_semantic_model)

Property	Description
name	Display name
owner	Owner/creator
is_published	Published to an app/workspace
storage_format	Import/DirectQuery/Composite
native_last_data_update	Last successful data refresh time
refresh_frequency	Scheduled refresh cadence
description	Dataset description/annotation
created_at	Timestamp for creation date
updated_at	Timestamp last modification
external_link	Deep link to open the dataset
is_enabled	Active/enabled flag
tags	User-defined tags
labels	System or user labels for categorization (sensitivity and endorsements labels)
total_impressions_14d/30d/60d	The number of sum of all impressions on the downstream dashboards, and reports over the last 14/30/60 days.
distinct_impressions_users_14d/30d/60d	The number of distinct users who triggered the impressions of the downstream dashboards and reports over the last 14/30/60 days.

Reports (powerbi_report)

name	Display name
subtype	Either "report" or "paginated report"
owner	Owner/creator
folder	Folder/grouping within workspace
is_published	Published to an app/workspace
description	Report description/annotation
created_at	Timestamp for creation date
updated_at	Timestamp last modification
external_link	Deep link to the report
is_enabled	Active/enabled flag
tags	User-defined tags
labels	System or user labels for categorization (sensitivity and endorsements labels)
total_impressions_14d/30d/60d	The number of impressions the resource is found within over the last 14/30/60 days.
distinct_impressions_users_14d/30d/60d	The number of distinct users who triggered the impressions of the resource over the last 14/30/60 days.

Pages (powerbi_page)

Property	Description
name	Page display name (from report metadata)
native_id	Page identifier (when exposed)
folder	Page grouping/order (if present)
external_link	Deep link to page (when resolvable)
created_at	Timestamp for creation date
updated_at	Timestamp last modification

Dashboards (powerbi_dashboard)

Property	Description
name	Display name
owner	Owner/creator
folder	Folder/grouping within workspace
is_published	Published to an app/workspace
description	Dashboard description/annotation
created_at	Timestamp for creation date
updated_at	Timestamp last modification
external_link	Deep link to the dashboard
is_enabled	Active/enabled flag
tags	User-defined tags
labels	System or user labels for categorization (sensitivity and endorsements labels)
total_impressions_14d/30d/60d	The number of impressions the resource is found within over the last 14/30/60 days.
distinct_impressions_users_14d/30d/60d	The number of distinct users who triggered the impressions of the resource over the last 14/30/60 days.

Tiles (powerbi_tile)

Property	Description
name	Tile title
subtype	One of: report (pinned visual/page), qna, streaming (static tiles ignored)
folder	Grouping within dashboard (if present)
labels	Labels applied to the tile
created_at	Timestamp for creation date
updated_at	Timestamp last modification
external_link	Deep link to the tile or its source
is_enabled	Active/enabled flag
total_impressions_14d/30d/60d	The number of impressions the resource is found within over the last 14/30/60 days.
distinct_impressions_users_14d/30d/60d	The number of distinct users who triggered the impressions of the resource over the last 14/30/60 days.

Apps (powerbi_app)

Property	Description
name	App name
users	Users who have access/usage context for the resource
groups	Groups with access/visibility to the resource
description	App description
created_at	Timestamp for creation date
updated_at	Timestamp last modification
external_link	Deep link to the app
is_enabled	Active/enabled flag
tags	User-defined tags
labels	System or user labels for categorization (endorsements labels)

Columns & Measures (powerbi_column & powerbi_measure)

Property	Description
name	Field name (column or measure)
parent	Table name within the dataset (or dataflow table)
native_data_type	Original data type (e.g., whole number, decimal, text, date)
normalized_data_type	Standardized type (string, number, date, boolean)
is_calculated	true if DAX (calculated column/measure) or M‑authored transformation
data_type	Semantic kind or measure category (if surfaced)
raw_code	DAX expression or M code when available (Scanner/XMLA)
description	Business description/notes
external_link	Deep link to the parent artifact (report/dataset model)
total_impressions_14d/30d/60d	The number of impressions the resource is found within over the last 14/30/60 days.
distinct_impressions_users_14d/30d/60d	The number of distinct users who triggered the impressions of the resource over the last 14/30/60 days.

Table (table)

The Power BI integration will discover resources of type Table when it identifies a dataset or dataflow referring to a database table. For example, if a data source is using a table from the data warehouse, which is not connected to dbt, or an integrated DW.

Property	Description
name	The name of the table.
database_technology	The technology of the database, based on the dialect of the connection
database	The name of the database
database_schema	The name of the schema

Relationships

The table below mirrors the format used in the BigQuery docs and captures structural (child) and lineage (upstream) relationships for Power BI/Fabric objects.

powerbi_workspace	child	powerbi_dataset, powerbi_report, powerbi_dashboard, powerbi_dataflow, powerbi_app	Direct children discoverable via Fabric/Power BI Items/Admin APIs.
powerbi_dataflow	upstream	table	Source tables/files (e.g., SQL/Lakehouse/Excel/CSV/SharePoint). Coverage depends on mashup metadata availability.
powerbi_dataset	upstream	powerbi_dataflow	When datasets consume dataflow outputs. Reported by …/datasets/upstreamDataflows and/or Scanner.
powerbi_dataset	upstream	table	DirectQuery/Import sources from …/datasets/{id}/datasources (e.g., server/db/schema).
powerbi_dataset	child	powerbi_column, powerbi_measure	Columns/measures come from Scanner (datasetSchema/expressions) or XMLA.
powerbi_report	child	powerbi_page	Pages enumerated via /reports/{id}/pages.
powerbi_report	upstream	powerbi_dataset	A report can reference one or more datasets.
powerbi_page	upstream	powerbi_dataset	Visuals on a page query dataset fields/measures (per‑visual field mapping requires Log Analytics).
powerbi_dashboard	child	powerbi_tile	Tiles discovered via /dashboards/{id}/tiles.
powerbi_tile	upstream	powerbi_report	For tiles pinned from report visuals or full pages.
powerbi_tile	upstream	powerbi_dataset	For Q&A tiles and streaming dataset tiles. Static tiles (text/image) have no lineage and are excluded.
powerbi_app	child	powerbi_dashboard, powerbi_report, powerbi_tile	Apps distribute dashboards/reports/tiles to audiences.
powerbi_column	upstream_fields	column powerbi_column	From source columns → table columns → dataflow columns → dataset columns; derived from Scanner mashup/schema and/or XMLA.
powerbi_measure	upstream_fields	powerbi_column, powerbi_measure	DAX references to columns and other measures (from Scanner expressions/XMLA).