Forum Discussion
External Tool to Update Dataflow Metadata??
We're using dataflows pretty heavily. Here's a situation we run into frequently:
Add a new column to an upstream dataflow.
Have several downstream dataflows.
We have to refresh upstream dataflow, then open each downstream data flow and save in order to add the new field.
Is there currently any way to add a new field metadata to a dataflow without opening it in PBI service?
No. I don't even see an idea for it though. What are you trying to accomplish? Even with an external tool, you'd have to edit the M code, save it, then initiate a refresh. What will the external tool provide that whe web UI isn't? Are you just trying to script a bunch of changes?
7 Replies
No. There is no XMLA endpoint for accessing dataflows at this stage. The REST API for dataflows let you manage many aspects of a dataflow, but not editing the M code. Dataflows - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Do you know if this is on the development roadmap?
No. I don't even see an idea for it though. What are you trying to accomplish? Even with an external tool, you'd have to edit the M code, save it, then initiate a refresh. What will the external tool provide that whe web UI isn't? Are you just trying to script a bunch of changes?
