Forum Discussion
External Tool to Update Dataflow Metadata??
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?
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?
I want to be able to edit the M code for all downstream dataflows, then refresh the upstream dataflow and have the data populate in the downstream dataflows. Currently, I have to:
1) Add the new field to the upstream dataflow
2) Refresh it
3) Wait for it to finish
4) Open the first downstream dataflow
5) Save it
6) Refresh it
7) Wait for refresh to finish
.... etc etc for each downstream dataflow
You can speed this up by editing the first dataflow and tell it to only keep the top 100 records. It should refresh in seconds. Then add that column to all downstream dataflows. Then remove that Keep top 100 records from the first dataflow and let all of them fully refresh.
An XMLA endpoint to edit won't fix that. You cannot add columns to downstream dataflows that don't exist yet in upstream.
That workaround may save me some time, thanks.
As for "You cannot add columns to downstream dataflows that don't exist yet in upstream"... Maybe I'm not understanding fully, but I would edit the upstream dataflow metadata, then the first downstream metadata, then the next, so the fields would exist in the upstream dataflow, it just wouldn't contain any data.