Cannot take over Dataflow Gen2

[SANKALP]

I tried the workaround by taking the json or power query template but it is not getting uploaded into the new dataflowGen2.

[frithjof_v · Accepted solution]

Perhaps this is a similar case:

https://community.fabric.microsoft.com/t5/Dataflows/Cannot-take-over-Dataflow-Gen2-anymore/m-p/40204...

The solution seems to be to export .json, and then open the .json in Notepad (or another tool), then copy each M code from the .json file and paste the M code into blank query (advanced editor) in a new Dataflow Gen2.

---

Maybe an alternative approach:

I haven't tried this, but maybe it's also possible to create a dataflow gen1 from the .json file (import json), and then export the dataflow gen1 as a power query template, and then import the power query template in a dataflow gen2.

Dataflow Gen2 (export json) -> new Dataflow gen1 (import json) -> Dataflow gen1 (export power query template) -> new Dataflow Gen2 (import power query template).

If that is possible.

Otherwise just export json from the original Dataflow gen2 and open the json in Notepad and copy the M code into a blank query in a new Dataflow gen2, as mentioned above.

[miguel · Accepted solution]

Hi!

This is a known issue that you can track on:

Known issue - Dataflow Gen2 ownership takeover fails - Microsoft Fabric | Microsoft Learn

The workarounds shared by @frithjof_v are valid.

[arpost]

@miguel, I'm glad there's at least a semblance of a workaround, but do we have any kind of timeline on a fix from Microsoft? If a user owned multiple dataflows and leaves the org, those dataflows could be tied into numerous pipelines, so importing a new one is NOT ideal as this would also impact all data pipelines.

[frithjof_v]

Why are you unable to take over the Dataflow Gen2? Is the option to take over greyed out?

For the Power Query Template approach, are you following the steps in this article: https://learn.microsoft.com/en-us/power-query/power-query-template

I think your new dataflow gen2 needs to be completely empty in order for the import of a power query template to work.

If you can share some screenshots (remember to not show sensitive information), it might help others in suggesting a solution for your case.

[frithjof_v · Accepted solution]

Perhaps this is a similar case:

https://community.fabric.microsoft.com/t5/Dataflows/Cannot-take-over-Dataflow-Gen2-anymore/m-p/40204...

The solution seems to be to export .json, and then open the .json in Notepad (or another tool), then copy each M code from the .json file and paste the M code into blank query (advanced editor) in a new Dataflow Gen2.

---

Maybe an alternative approach:

I haven't tried this, but maybe it's also possible to create a dataflow gen1 from the .json file (import json), and then export the dataflow gen1 as a power query template, and then import the power query template in a dataflow gen2.

Dataflow Gen2 (export json) -> new Dataflow gen1 (import json) -> Dataflow gen1 (export power query template) -> new Dataflow Gen2 (import power query template).

If that is possible.

Otherwise just export json from the original Dataflow gen2 and open the json in Notepad and copy the M code into a blank query in a new Dataflow gen2, as mentioned above.

[frithjof_v]

Just want to share:

I tested the alternative approach, and it seems not to be possible, because a .json exported from a Dataflow Gen2 cannot be imported into a Dataflow Gen1.