Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
scurrp
Frequent Visitor

How can I programmatically read Power Query dataflow metadata?

I want to return metadata like the power query dataflow name so if the name changes the metadata will reflect the updated name. 

What I'm thinking is a number of system variables that can be queried in the dataflow:
Something like
_.dataflow.Name - this is the name of the dataflow that is indicated in the title
_.dataflow.TableName

_.dataflow.WorkspaceName

1 REPLY 1
edhans
Super User
Super User

The only way to read metadata about dataflows is using the REST API. See Dataflows - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Some of what you want is there, but not everything directly. The Get Dataflow command though will export the entire dataflow definition to a JSON file, and that will have table names, column names, even column data types. You will just need to parse out the JSON file.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.