Query sources for.... source tables

[decarsul]

Hi all!

Recently i got notified that in one of our database's a few changes are going to be made. It is now my task to investigate the possible impact on published dashboards. Changes include column name changes and datatype changes.

We address this database by querying directly with SQL to it, to import this data to a dataflow or dataset. And in most cases, the tables that are being altered are also part of unions and joins (see screenshot below for a sample of the lineage).

Now i'm looking for a way to be able to quickly check if these tables and columns are part of source query's. But i only seem to be able to see the 'source' via lineage, but not the actual query on that source without opening each dataset or dataflow individually. (and with atleast 150 published reports over 2 or 3 workspaces, this is tedious)

Is there any way to get a quick overview, or export even, where i can view the actual query's?

[lbendlin · Accepted solution]

there are ways, but none of them are "quick".

Enumerate your semantic models, then run DMV queries against the partitions and expressions for each.

For dataflows you are out of luck - there you need to export the .json manually for each of them.

[decarsul]

That is a shame... oh well!