Visualising Object Dependencies

[Griffin_BI]

Hello, 

I'd like to use a visual to show object dependencies within an Extract, Transform, Load (ETL) procedure in a database. I can build a full list of parent to child dependencies from load files to stored procedures to built tables and views. What is the best visual to show this?  I am open to Python script visualisations also.

Thanks!

[V-lianl-msft · Accepted solution]

Hi @Griffin_BI ,

See if Query Dependency View in Power BI Desktop can meet your needs:

For DAX measure,You can refer to this blog:

https://www.biinsight.com/dax-measure-dependencies-in-ssas-tabular-and-power-bi/ 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

There are a couple of network themed visuals that you can choose from (search with the "network" keyword).  Have you considered using the built-in lineage view instead?