Source information with DMV or INFO.DAX function
I am using a dataflow Gen2 to write back metadata about my PowerBI dataset. To make a complete view of my data lineage I would like to extract the sources of my partitions. I have used the TMSCHEMA_Partitions DMV function to retrieve this information (the same result can be achieve by using the INFO.Partitions DAX function). For tables/partitions that I did not alter in PowerQuery I can find the source table, but for others only the last step of the PowerQuery definition is shown. See below Does anyone know a method on how to retrieve the source information of my partitions/tables in my PowerBI dataset? Thank you!
