Salil Athalye on 11 Apr 2024 12:30:08
When we extract metadata that includes Power Query expressions we get a long string that contains the expression but it is difficult to parse in order to extract all the intermediate and final tables that are involved in the transformation. Could we get JSON objects that refer to all of the entities (tables, workspaces) that were referenced in the Power Query transformation. Ideally this would help us build out the data lineage graph if these entities had GUIDs associated with them. This would really be helpful for Measures as well so that they could become first-class entities whose provenance and lineage could be tracked.