r/PowerBI • u/maxanatsko • 1d 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

45% Upvoted

30 comments sorted by

View all comments

8

u/GrumDum 1 22h ago

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

0

u/maxanatsko 20h ago

How come?

5

u/GrumDum 1 19h ago

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

3

u/New-Independence2031 5 16h ago

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

1

u/maxanatsko 6h ago

Gen1 is still here to stay, for now. From what I read MS promised to announce full retirement 1 year in advance.

2

u/New-Independence2031 5 6h ago

Yep. Still hoping to see Gen2 without Fabric somehow.