Forum Discussion
Cannot take over Dataflow Gen2
Perhaps this is a similar case:
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.
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.
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.
Perhaps this is a similar case:
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.
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.