topic Re: Cannot take over Dataflow Gen2 in Dataflow

Cannot take over Dataflow Gen2

Anonymous — Mon, 08 Jul 2024 10:59:57 GMT

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

Re: Cannot take over Dataflow Gen2

frithjof_v — Mon, 08 Jul 2024 12:46:00 GMT

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.

Re: Cannot take over Dataflow Gen2

frithjof_v — Mon, 08 Jul 2024 13:07:29 GMT

Perhaps this is a similar case:

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

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.

Re: Cannot take over Dataflow Gen2

miguel — Mon, 08 Jul 2024 16:07:00 GMT

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.

Re: Cannot take over Dataflow Gen2

arpost — Mon, 08 Jul 2024 16:28:59 GMT

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.

Re: Cannot take over Dataflow Gen2

frithjof_v — Thu, 11 Jul 2024 08:45:50 GMT

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.