Dataflow and export json option

[prathyoo]

Hi,

In dataflow gen2, we have the option to Export .json. But, how do we import the json back?

Regards

[Jenifercrook45]

In the Import Dataflow dialog, click on the "Browse" Button and select the JSON file you want to import. Once the JSON file is selected, click on the "import" Button to initiate the import process. Data Factory will import the JSON file and create a new DATAflow based on the Import process is completed, you should see the imported Dataflow listed in the Dataflows tab.

[miguel]

This will effectively be for a Dataflow Gen1 (in Power BI), but not for a new Dataflow Gen2 in Data Factory.

[miguel · Accepted solution]

There is currently not an option to import from a .json file. However, you do have the ability to export and import from a template. Below is the link that talks more about Power Query templates:

Power Query template (preview) - Power Query | Microsoft Learn