Share via

How can I programmatically read Power Query dataflow metadata?

Scurr, Peter 0 Reputation points
2023-07-27T08:06:46.2333333+00:00

I want to return metadata like the power query dataflow name so if the name changes the metadata will reflect the updated name. note - Power Query / data flows wasn't a tag option :(

Here's a mock up of what I'm thinking, where properties.dataflow.name is the name of the dataflow that is indicated in the image ie "Hierarchy"
User's image

#"Add Name" = Table.TransformColumnTypes(Table.AddColumn(#"Changed Type", "Name", each properties.dataflow.name ),   {{"Name", type text}} ),
Community Center | Not monitored

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.