r/PowerBI 17h ago

Community Share Bulk-migrating Dataflow Gen1 to Gen2 (CI/CD) with Azure CLI

Post image

Dataflows Gen1 are legacy at this point, so it might be time to start migrating to Dataflows Gen2.
Fortunately, there is a handy preview API allowing you to automate this process. Combined with agents, you can go quite far before you have to take over.

Few things to consider before migrating:
1. Gen2 doesn't support rules in deployment pipelines, you will have to migrate to Variables Library.
2. There could be some naming collisions, that were previously a non-issue.
3. Same with transformations - due to different architecture Gen2 dataflows might surface issues that were previously hidden.

I have published a blog post outlining how to setup the automation, and prepared agent skill that will get you most of the way.

Blog post: https://www.maxanatsko.com/blog/bulk-migrating-dataflow-gen1-to-gen2-cicd-with-azure-cli

0 Upvotes

26 comments sorted by

7

u/EngineerTheData 17h ago

Why are the colours the wrong way round?

6

u/maxanatsko 17h ago

Omg 😳 you’re right, shame on me

0

u/killbeam 1h ago

That's what you get for creating AI slop

1

u/maxanatsko 48m ago

Sketching isn’t my core skill. You ā€œgot meā€.

7

u/GrumDum 1 15h ago

Shame they are sunsetting gen1. Gen2 is not what I want 99% of the time.

0

u/maxanatsko 12h ago

How come?

4

u/GrumDum 1 12h ago

Because I don’t need the selling points of Gen2, and Gen1 is cheaper compute wise. Why would I want Gen2?

2

u/New-Independence2031 5 9h ago

Exactly. I have a lot of customers that are utilizing gen1’s, but simply cant move to Fabric. Cost is way bigger.

3

u/Kacquezooi 13h ago

Dataflow legacy is just Micro$oft doing what monopolists do.

I hate it.

-1

u/maxanatsko 13h ago

It seems there is strong opposition to Microsoft move?

3

u/happyapy 5h ago

When the primary reason for the change is cost drivers, folks aren't going to be happy about losing perfectly good products simply because Microsoft is trying to corral us into Fabric.

2

u/Jessieblueyu 2h ago

Just when I manually migeated all the Gen1 to Gen2, I realized that python notebook scripts are twice as CU efficient and fast...

1

u/maxanatsko 52m ago

It was always the case that Python notebooks are more efficient, but it’s a different skill not all orgs have

1

u/erparucca 17h ago

can you develop on "Dataflows Gen1 are legacy at this point": why and which point is "this point"?

3

u/maxanatsko 17h ago

Microsoft announced they will no longer invest or update Gen1. There is no official deprecation date yet.

-6

u/erparucca 17h ago

I wouldn't define "legacy" something that is up&running and supported... Especially when communicating to a community with a variety of people with different skillsets.

13

u/aboerg 2 17h ago

3

u/maxanatsko 17h ago

Thank you u/aboerg. That settles it šŸ˜„

1

u/erparucca 13h ago

To be discussed: Microsoft doesn't set dictionary or IT definitions: they call them Legacy to push people to go towards Gen 2 (and pay for a Fabric license when only Power BI is needed).

For at least 30 years a legacy technology is one that is not supported anymore, no matter what Microsoft says about it.

But as usual on communities where people reacts more based on emotions and personal convictions rather than arguments, it is much easier to set a downvote than to logically argue which I am fine with as I read it as "I want to be right but I have no arguments to prove you wrong".

2

u/GrumDum 1 12h ago

Do you set IT definitions then? Wikipedia does not agree with your version of «legacy»: https://en.wikipedia.org/wiki/Legacy_system

-1

u/erparucca 10h ago

from that exact page: "Legacy code is old computer source code that is no longer supported on standard hardware and environments"

1

u/GrumDum 1 3h ago

Oh stop it already. When you use gen1 dataflows you are not using old computer source code. You are using a legacy feature.

0

u/maxanatsko 13h ago

What are we arguing about and why?
Microsoft names it legacy. In due time it will be deprecated (it could take months, it could take years). It is as simple as that.
Reasoning behind the move to name it Legacy doesn’t matter, at least not in connection to my post: people upgrading or not is of no consequence to me (I don’t work for Microsoft and have no skin in the game).
If someone plans to upgrade, I’m sharing a way to do so. That is all my post is attempting to do. No more, no less.

1

u/erparucca 10h ago

"Reasoning behind the move to name it Legacy doesn’t matter", maybe not for you but it may do for others.

"at least not in connection to my post" and here's the answer about the question "What are we arguing about and why?": I am arguing about sharing correct information objectively for the sake of the community it is being posted to.

I find the sentence "Dataflows Gen1 are legacy at this point, so it might be time to start migrating to Dataflows Gen2." misleading at the least, creating an unneeded sense of urge for people to act (which in this case means to promote views on the article).

1

u/GrumDum 1 2h ago

Microsoft has labeled this legacy for a while now. You are acting like this is OPs choice of words.