What to Expect
Dataedo imports automatically:
- Repors, visualizations and fields
- Data sets, tables and columns
- Column-level lineage from datasets - reports
- Column-level lineage from source database tables to data sets
SQL Server → Power BI
Lineage is created from Tables and Views in SQL Server to Dataset Tables in Power BI and from Dataset Tables to Power BI Reports. It is created at the column level. Supported Data Connectivity modes: Import and Direct Query
Microsoft Fabric Data Lakehouse → Power BI
Lineage is created from Tables in Microsoft Fabric Data Lakehouse to Dataset Tables in Power BI and from Dataset Tables to Power BI Reports. It is created at the column level. Supported Data Connectivity modes: OneLake, Import and Direct Query.
Microsoft Fabric Data Warehouse → Power BI
Lineage is created from Tables in Microsoft Fabric Data Warehouse to Dataset Tables in Power BI and from Dataset Tables to Power BI Reports. It is created at the column level. Supported Data Connectivity modes: OneLake, Import and Direct Query.
PostgreSQL → Power BI
Lineage is created from Tables and Views in PostgreSQL to Dataset Tables in Power BI and from Dataset Tables to Power BI Reports. It is created at the column level. Supported Data Connectivity modes: Import and Direct Query.
MySQL → Power BI
Lineage is created from Tables and Views in MySQL to Dataset Tables in Power BI and from Dataset Tables to Power BI Reports. It is created at the column level. Supported Data Connectivity modes: Import and Direct Query.
SQL Server Analysis Services Tabular - import mode → Power BI
Lineage is created from Tables in SQL Server Analysis Services Tabular to Dataset Tables in Power BI and from Dataset Tables to Power BI Reports. It is created at the column level. Supported Data Connectivity modes: Import and Live Connection
SQL Server Analysis Services Tabular - live connection mode → Power BI
SQL Server Analysis Services Multidimensional → Power BI
Lineage is created from Cubes in SQL Server Analysis Services Tabular to Dataset Tables in Power BI (only for cubes measures) and from Dataset Tables to Power BI Reports. It is created at the column level. Supported Data Connectivity modes: Import and Live Connection
Snowflake → Power BI
Lineage is created from Tables i Snowflake to Dataset Tables in Power BI and from Dataset Tables to Power BI Reports. It is created at the column level. Supported Data Connectivity modes: Import and Direct Query.
SQL Server → Power BI Paginated Report
Lineage is created from Tables and Views in SQL Server to Paginated Reports Datasets in Power BI and from Paginated Reports Datasets to Paginated Reports. It is created at the column level.
Power BI Dataset → Power BI Paginated Report Dataset → Power BI Paginated Report
Lineage is created from Datasets in Power BI to Paginated Reports Datasets in Power BI and from Paginated Reports Datasets to Paginated Reports. It is created at the object level.
Data Connectivity mode
Data Connectivity mode is a way of storing tables in datasets. It is determined when creating a dataset in Power BI.
Dataedo creates lineage in the above cases for this data connectivity modes: - Import - DirectQuery - Live Connection
Known Limitations
- Column lineage is created on the basis of matching column names, if such names are changed manually, the lineage may not be matched correctly.
- If the Dataset uses MS Fabric Data Warhouse and MS Fabric Data Lakehouse at the same time, the lineage of only one of these two will be adjusted. Manually correcting Linked Sourc will solve the problem.
- SSAS Multidimensional does column lineage only for cube measures.
- For Power Bi on prem (Power Bi Report Server) we do not create a lineage .
Troubleshooting
Lineage is created based on a matched Linked Source, check the Dataedo desktop to make sure it is matched properly.