Forum Discussion
davidfombella
Jul 24, 2026Copper Contributor
Data Product Lineage not automatic
Hi all i am new in Purview and I am trying to create a lineage with a Report--> Dataset--> Tables in Data Products however after adding report only dataset is shown, how can I view all tables of this...
jamesmithofficial
Jul 25, 2026Copper Contributor
Hi David,
Two things to note:
- Table-level lineage isn't automatic for most datasets — Purview shows item-level lineage (Dataflow → Dataset → Report), but table/column-level detail only works if the source is Azure SQL Database. Other sources won't expand tables in the graph.
- The table list under "Open in Fabric" is controlled by Fabric workspace permissions, not Purview. To grant access, set roles at the workspace level or via "Manage permissions" on the semantic model itself.