Forum Discussion

Quincy_w's avatar
Quincy_w
Copper Contributor
Sep 21, 2023

PowerBI lineage with SQL server database connector problems

Hi,

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

Correct lineage

No RepliesBe the first to reply

Resources