PowerBI lineage with SQL server database connector problems

Copper Contributor


I want to show the lineage of my PowerBI reports in PurView. The reports retrieves its views with the SQL server database connector. When I do a full scan in Purview, the lineage is not fully shown in some reports. The reports that do not show a correct lineage only show the database name as source (see Incorrect lineage) while the reports that do show a correct lineage show all views used and the name of the database (see Correct lineage). The views used in the reports that are not shown correctly in terms of lineage are all loaded into the report and are also used in the data model in PowerBi. Does anyone have an explanation why the lineage is not always shown correctly?

Incorrect lineage
Incorrect lineage.png
Correct lineage
Correct lineage.png

0 Replies