Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

How to update dataflow M scripts from JSON file?

Hi, I have created a dataflow in a developer workspace, then exported the dataflow as a JSON file and imported the dataflow from the JSON file into a production workspace, all successfully. Then I h...
Need Help
FADAVI's avatar
FADAVI
Frequent Visitor
1 year ago

Hi, 

I know it is an old post, it seems it's still impossible to overwrite a DF with a JSON template. 

There is a little tip to help:
In your queries which use the DF connector you can change the navigation steps in order to mention the dataflowName instead of the dataflowId.
Example:

let
   Source = PowerBI.Dataflows([]),
   WS = Source{[workspaceName="your_workspace_name"]}[Data],
   DF = WS{[dataflowName="your_dataflow_name"]}[Data]
in
   DF


If you do that you can delete the old DF and import the JSON file with the updated version. You will not have to modify the queries wich mention this DF.

Florian