How to get lineage of a synapse object (table/view) across all datasets in workspace/tenant level

[Jerinfonterra]

Is there any way we can track where all a table/view is used in all datasets in powerbi across workspace/tenant level?

[v-xiaoyan-msft]

Hi  @Jerinfonterra ,

Every workspace automatically has a lineage view.In lineage view, you see the lineage relationships between all the items in a workspace, as well as data sources external to the workspace one-step upstream.

Note:

Lineage in Fabric is in preview, and not all connections between items are fully supported yet. It is possible that the lineage between some items will be incorrectly shown.

For more you may refer to:Lineage in Fabric - Microsoft Fabric | Microsoft Learn

Best regards.
Community Support Team_Caitlyn

[Jerinfonterra]

Hi @v-xiaoyan-msft 

thanks for the response. What Im looking for is some thing in the database object level. ie if I need to remove a particular object from database (synapse) I need to know which all datasets uses this object to understand the dependency