Forum Discussion
DMV issue
AlexisOlson bcdobbs
Is there any DMV query you know of that can return the downstream depndencies (report/s) for a given dataset?
I haven't used DMV queries much. Does the lineage view or dataset impact analysis help at all?
AlexisOlson I was wondering if there is a way to progrmatically determine what the lineage is giving graphically. I want to track the children forEach parent. I don't think DMV would be correct for this task. I probaly ned to use PowerBI's rest API to track all the workspace URL and track them from there. The issue is POWER BI REST APIs do not have a connector (I wish there was that is useable at workspace) which makes the task hard.
