Power BI operating model

The lineage harvester collects Power BI metadata and sends it to the Collibra Data Lineage server. Collibra processes the metadata and creates new Power BI 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 Power BI. Full names and Display names cannot be changed in Data Catalog.
Asset types are only created if you have all specific Power BI and Data Catalog permissions.
The Power BI assets are created in the domain (or domains) that you specify in the lineage harvester configuration file.
Relations that were created between Power BI assets and other assets via a relation type in the Power BI operating model, are deleted upon synchronization. The same is true of any attribute types in the operating model that you add to Power BI assets. To ensure that the characteristics you add to Power BI assets are not deleted upon synchronization, be sure to use characteristics that are not part of the Power BI operating model.

Power BI metadata overview

The following image shows the relations between Power BI asset types.

Harvested metadata per asset type

This table shows the harvested Power BI metadata for each Power BI asset type.

Asset type	Harvested Power BI metadata in Data Catalog
Power BI Capacity	Full name Display name Server hosts / is hosted in Business Dimension BI Folder assembles / is assembled in BI Folder
Power BI Column	Full name Display name Description Role in Report Technical Data Type Data Element targets / sources Data Element BI Data Model contains / is part of BI Data Attribute Data Entity contains / is part of Data Attribute
Power BI Dashboard	Full name Display name URL BI Data Set is source / Source for BI Report Report uses / used in Report Report related to / impacted by Business Asset
Power BI Data Flow	Full name Display name Data Entity is part of / contains Data Model BI Data Model contains / is part of BI Data Attribute BI Folder contains / contained in Data Asset
Power BI Data Model	Full name Display name Owner in source The only harvested metadata are email addresses. Data Asset is source for / source BI report Data Entity is part of / contains Data Model BI Data Model contains / is part of BI Data Attribute BI Folder contains / contained in Data Asset
Power BI Report	Full name Display name Description URL Business Dimension groups / is grouped into Report Report related to / impacted by Business Asset Report uses / used in Report Data Asset is source for / source BI Report
Power BI Server	Full name Display name Server hosts / is hosted in Business Dimension
Power BI Table	Full name Display name Description Data Entity contains / is part of Data Attribute Data Entity is part of / contains Data Model
Power BI Tile	Full name Display name URL Business Dimension groups / is grouped into Report Report related to / impacted by Business Asset Report uses / used in Report Data Asset is source for / source BI Report
Power BI Workspace	Full name Display name Description State Owner in source The only harvested metadata are email addresses. BI Folder contains / contained in Data Asset BI Folder assembles / is assembled in BI Folder Business Dimension groups / is grouped into Report

Note The metadata that is shown on the assets' pages depends on the asset type's assignment. As a result, you might not see all harvested metadata on the asset's page by default.

Additional information

For the Owner in source attribute, the following rules apply:

If the system creates a Power BI data object and the Power BI data object does not have a user ID, the Owner in source attribute is shown as System on the asset page.
If the user who created a Power BI data object no longer exists, the Owner in source attribute is shown as empty on the asset page.

Example of ingested Power BI metadata

The following image shows an example structure after Power BI ingestion.

Recommended hierarchy within a domain

You can enable hierarchies for the domain (or domains) in which your Power BI assets were ingested. Doing so makes it easier to understand the relation between your Power BI assets, when viewing the assets on the domain page.

Follow these steps to enable and configure the recommended hierarchy.

Steps

Open the domain page of the relevant BI Catalog domain.
On the content toolbar, click .
The Configure Hierarchy dialog box appears.
Select Enable Hierarchy.
Select Single path.
Start typing and select each of the following relation types:
- Server hosts Business Dimension
- BI Folder assembles BI Folder
- Business Dimension groups Report
- BI Report source Data Asset
- Data Model contains Data Entity
- Data Entity contains Data Attribute
Click Apply.

Note In an asset view, if any asset is deleted, for example via synchronization or manual deletion, the view is recreated and the hierarchy is lost. In this case, you can again enable and configure the recommended hierarchy.

Create a Power BI operating model diagram view

You can create a Power BI-specific diagram view, to visualize the operating model. The following procedure provides instruction on how to quickly create a new diagram view by copying and pasting the JSON code in the diagram view text editor.

Steps

Open an asset page.
In the tab pane, click Diagram.
The diagram appears in the default diagram view.
Click to add a new view.
Click the Text tab, to switch to the diagram view text editor.
Click Show me the JSON code below this procedure, to expand the code.
Click in the top-right of the expanded code, to copy the code.
The code is copied to your clipboard.
Paste the code in diagram view text editor.
Click Save.
Edit the name and description of the diagram view, to suit your needs.

Show me the JSON code

Copy code

{
	"nodes": [
		{
			"id": "Power BI Server",
			"type": {
			  "id": "00000000-0000-0000-0000-100000000001"
		},
			"fields": []
		},
		{
			"id": "Power BI Capacity",
			"type": {
			  "id": "00000000-0000-0000-0000-100000000002"
			}
		},
		{
			"id": "Power BI Workspace",
			"type": {
			  "id": "00000000-0000-0000-0000-100000000003"
			}
		},
		{
			"id": "Power BI Dashboard",
			"type": {
			  "id": "00000000-0000-0000-0000-100000000004"
			}
		},
		{
			"id": "Power BI Report",
			"type": {
			  "id": "00000000-0000-0000-0000-100000000006"
			}
		},
		{
			"id": "Power BI Tile",
			"type": {
			  "id": "00000000-0000-0000-0000-100000000005"
			}
		},
		{
			"id": "Power BI Data Model",
			"type": {
			  "id": "00000000-0000-0000-0000-100000000007"
			}
		},
		{
			"id": "Power BI Data Flow",
			"type": {
	   		  "id": "00000000-0000-0000-0000-100000000010"
			}
		},
		{
			"id": "Power BI Table",
			"type": {
			  "id": "00000000-0000-0000-0000-100000000009"
			}
		},
		{
			"id": "Power BI Column",
			"type": {
			  "id": "00000000-0000-0000-0000-100000000008"
			}
		}
	],
	"edges": [
		{
			"from": "Power BI Server",
			"to": "Power BI Capacity",
			"label": "",
			"style": "arrow",
			"type": {
			  "id": "00000000-0000-0000-0000-120000000000"
			},
			"roleDirection": true
		},
		{
			"from": "Power BI Capacity",
			"to": "Power BI Workspace",
			"label": "",
			"style": "arrow",
			"type": {
			  "id": "00000000-0000-0000-0000-120000000001"
			},
			"roleDirection": true
		},
		{
			"from": "Power BI Workspace",
			"to": "Power BI Dashboard",
			"label": "",
			"style": "arrow",
			"type": {
			  "id": "00000000-0000-0000-0000-120000000002"
			},
			"roleDirection": true
		},
		{
			"from": "Power BI Workspace",
			"to": "Power BI Report",
			"label": "",
			"style": "arrow",
			"type": {
			  "id": "00000000-0000-0000-0000-120000000002"
			},
			"roleDirection": true
		},
		{
			"from": "Power BI Workspace",
			"to": "Power BI Tile",
			"label": "",
			"style": "arrow",
			"type": {
			  "id": "00000000-0000-0000-0000-120000000002"
			},
			"roleDirection": true
		},
		{
			"from": "Power BI Workspace",
			"to": "Power BI Data Model",
			"label": "",
			"style": "arrow",
			"type": {
			  "id": "00000000-0000-0000-0000-120000000014"
			},
			"roleDirection": true
		},
		{
			"from": "Power BI Workspace",
			"to": "Power BI Data Flow",
			"label": "",
			"style": "arrow",
			"type": {
			"id": "00000000-0000-0000-0000-120000000014"
			},
			"roleDirection": true
		},
		{
			"from": "Power BI Dashboard",
			"to": "Power BI Tile",
			"label": "",
			"style": "arrow",
			"type": {
			  "id": "00000000-0000-0000-0000-120000000007"
			},
			"roleDirection": true
		},
		{
			"from": "Power BI Data Model",
			"to": "Power BI Tile",
			"label": "",
			"style": "arrow",
			"type": {
			  "id": "00000000-0000-0000-0000-120000000013"
			},
			"roleDirection": true
		},
		{
			"from": "Power BI Data Model",
			"to": "Power BI Report",
			"label": "",
			"style": "arrow",
			"type": {
			  "id": "00000000-0000-0000-0000-120000000013"
			},
			"roleDirection": true
		},
		{
			"from": "Power BI Data Model",
			"to": "Power BI Table",
			"label": "",
			"style": "arrow",
			"type": {
			  "id": "00000000-0000-0000-0000-000000007196"
			},
			"roleDirection": true
		},
 		{
			"from": "Power BI Data Flow",
			"to": "Power BI Data Flow",
			"label": "",
			"style": "arrow",
			"type": {
			  "id": "00000000-0000-0000-0000-000000007046"
			},
			"roleDirection": true
		},
		{
			"from": "Power BI Data Flow",
			"to": "Power BI Table",
			"label": "",
			"style": "arrow",
			"type": {
			  "id": "00000000-0000-0000-0000-120000000014"
			},
			"roleDirection": true
		},
		{
			"from": "Power BI Tile",
			"to": "Power BI Report",
			"label": "",
			"style": "arrow",
			"type": {
			 "id": "00000000-0000-0000-0000-120000000007"
			},
			"roleDirection": true
		},
		{
			"from": "Power BI Table",
			"to": "Power BI Column",
			"label": "",
			"style": "arrow",
			"type": {
			  "id": "00000000-0000-0000-0000-000000007047"
			},
			"roleDirection": true
		},
		{
			"from": "Power BI Data Flow",
			"to": "Power BI Report",
			"label": "",
			"style": "arrow",
			"type": {
			  "id": "00000000-0000-0000-0000-000000007196"
			},
			"roleDirection": true
		}
	],
	"showOverview": false,
	"enableFilters": true,
	"showLabels": true,
	"showFields": true,
	"showLegend": true,
	"showPreview": true,
	"visitStrategy": "directed",
	"layout": "HierarchyTopBottom",
	"maxNodeLabelLength": 50,
	"maxEdgeLabelLength": 30,
	"layoutOptions": {
		"compactGroups": false,
		"componentArrangementPolicy": "topmost",
		"edgeBends": true,
		"edgeBundling": true,
		"edgeToEdgeDistance": 5,
		"minimumLayerDistance": "auto",
		"nodeToEdgeDistance": 5,
		"orthogonalRouting": true,
		"preciseNodeHeightCalculation": true,
		"recursiveGroupLayering": true,
		"separateLayers": true,
		"webWorkers": true,
		"nodePlacer": {
			"barycenterMode": true,
			"breakLongSegments": true,
			"groupCompactionStrategy": "none",
			"nodeCompaction": false,
			"straightenEdges": true
		}
	}
}