Forum Discussion
Visualize data lineage
Hi Anonymous ,
Based on my research, There is no such kind of visual in power bi currently. I suggest you to use decomposition tree to work around.
The decomposition tree visual in Power BI lets you visualize data across multiple dimensions. It automatically aggregates data and enables drilling down into your dimensions in any order.
You can try Sankey diagram to show visual data linage, I think it is the closest match for your requirement.
To use sankey you have to transform your data in source and destination columns(or nodes) like shown below, and add a dummy Weigh column.
To transform your data simply follow this logic : All the nodes which are acting as a source for other nodes will be listed in source column and all the nodes which are acting as a destination for other nodes will be listed in Destination column.
(e.g. in your data Colum Table 1 (attribute level) is source for column Table 2(attribute level) and column Table 2 is source for Table 3 so on and so forth. So Table1 (attribute level) and Table2 (attribute level) will appear in source column list and Table2 (attribute level) and Table3 (attribute level) will appear in destination column list)
Source | Destination | Weigh |
| Value of product | Attribute100 | 1 |
| Value of product | Attribute100 | 1 |
| Value of product | Attribute100 | 1 |
| Value of product | Attribute101 | 1 |
| Value of product | Attribute102 | 1 |
| Value of product | Attribute103 | 1 |
| Value of product | Attribute104 | 1 |
| Value of product | Attribute105 | 1 |
| Value of product | Attribute105 | 1 |
| Value of product | Attribute105 | 1 |
| Value of product | Attribute106 | 1 |
| Value of product | Attribute107 | 1 |
| Value of product | Attribute108 | 1 |
| Value of product | Attribute108 | 1 |
| Value of product | Attribute108 | 1 |
| Value of product | Attribute109 | 1 |
| Value of product | Attribute110 | 1 |
| Value of product | Attribute110 | 1 |
| Value of product | Attribute111 | 1 |
| Attribute100 | Attribute_x | 1 |
| Attribute100 | Attribute_x | 1 |
| Attribute100 | Attribute_y | 1 |
| Attribute102 | Attribute_z | 1 |
| Attribute105 | Attribute_x | 1 |
| Attribute105 | Attribute_x | 1 |
| Attribute105 | Attribute_y | 1 |
| Attribute108 | Attribute_x | 1 |
| Attribute108 | Attribute_x | 1 |
| Attribute108 | Attribute_y | 1 |
| Attribute109 | Attribute_z | 1 |
| Attribute110 | Attribute_x | 1 |
| Attribute110 | Attribute_x | 1 |
| Attribute_x | System_1 | 1 |
| Attribute_x | System_2 | 1 |
| Attribute_y | System_2 | 1 |
| Attribute_z | System_1 | 1 |
| Attribute_x | System_1 | 1 |
| Attribute_x | System_2 | 1 |
| Attribute_y | System_2 | 1 |
| Attribute_x | System_1 | 1 |
| Attribute_x | System_2 | 1 |
| Attribute_y | System_2 | 1 |
| Attribute_z | System_1 | 1 |
| Attribute_x | System_1 | 1 |
| Attribute_x | System_2 | 1 |
The output of Sankey diagram is shown below: