DMV issue

[smpa01]

@AlexisOlson @bcdobbs 

Is there any DMV query you know of that can return the downstream depndencies (report/s) for a given dataset?

[AlexisOlson]

I haven't used DMV queries much. Does the lineage view or dataset impact analysis help at all?

[smpa01]

@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.