Skip to main content
Microsoft Idea

Power BI

Completed

Deployment pipelines to support dataflows

Vote (103) Share
Robert Power BI User's profile image

Robert Power BI User on 22 May 2020 13:12:59

Deployment pipelines do not currently support Dataflows. In our organisation, we want to carefully govern a particular workspace which will contain the common dataflows which people want to use in many reports (e.g. a dates table, a list of active employees (GDPR permitting, etc).

Deployment pipelines will enable us to put the right governance in place for Dataflows.

Administrator on 15 Jul 2023 14:05:40

Deployment pipelines now supports dataflows as preview.
Please check out the docs- Get started using deployment pipelines, the Power BI Application lifecycle management (ALM) tool - Power BI | Microsoft Docs

Comments (11)
Robert Power BI User's profile image Profile Picture

on 22 Jun 2021 06:58:09

RE: Deployment pipelines to support dataflows

We need the ability to have real DTAP for dataflows that have linked entities.

For each stage in my DTAP process I have a pair of ingestion and transform dataflow workspaces. The transform dataflow uses linked entities from the ingestion dataflow workspace. Since the linked entities cannot be edited in the transform dataflow workspace there is no way to parameterize the link. What I'd like is the ability to point the linked entity to the correct version of the ingestion entity. This way, when I promote the code from dev to test, I can change the linked entity via the parameter.

Since the linked entities are incorporated into the JSON file for an entity, if I were to promote a set of changes to the entity dataflow from dev to test by importing the JSON, it would be pointing to the dev version of the ingestion entities.

Ideally, I could create a Power Query parameter that could set up the linked entities to point to the correct ingestion workspace entities based on stage in the DTAP pipeline. Then the code I write in dev could migrate through the process without significant rework and potential for defects from manual changes to the files.

Robert Power BI User's profile image Profile Picture

Kevin Wilson on 04 Jun 2021 16:49:40

RE: Deployment pipelines to support dataflows

Any update on ETA?

Robert Power BI User's profile image Profile Picture

Debbie Edwards on 01 Mar 2021 12:20:26

RE: Deployment pipelines to support dataflows

Hi,

we have had to make the decision to not run with Deployment Pipelines until Dataflows is part of the process.

can anyone give us an ETA on this please so we can at least give the customer some kind of timeline?

Robert Power BI User's profile image Profile Picture

Karim DEROUICH on 12 Jan 2021 14:10:49

RE: Deployment pipelines to support dataflows

vote

Robert Power BI User's profile image Profile Picture

Ginevra Jakobsen-Mendes on 11 Jan 2021 13:55:06

RE: Deployment pipelines to support dataflows

When can we expect this to be available?I read here that it is in the backlog: https://community.powerbi.com/t5/Service/Dataflows-are-supported-in-Power-BI-Pipelines/td-p/1173609

Robert Power BI User's profile image Profile Picture

Magnus Lander on 19 Nov 2020 13:42:20

RE: Deployment pipelines to support dataflows

Would love to see this. Not having this makes pipelines less useful and more complicated than needed to. A shame, because feeding datasets from multiple dataflows is a great set-up.

Robert Power BI User's profile image Profile Picture

Salil Athalye on 25 Sep 2020 13:38:24

RE: Deployment pipelines to support dataflows

Upvote on the need to deploy JSON scripts for Dataflows so that we have true DTAP on the ingestion/transformation phases. We also need support for parameterization of linked entities in DTAP so that when we promote our transformation dataflow which uses linked entities from DEV to TEST, the linked entities switch to the TEST set. I think since everything is placed in the same JSON file, it would overwrite the linkages and set everything to DEV linked entities.

Robert Power BI User's profile image Profile Picture

Joel Clark on 10 Jul 2020 17:22:19

RE: Deployment pipelines to support dataflows

Definitely need this, we can't use pipelines without it - everything is done through DFs in our Org. Thanks

Robert Power BI User's profile image Profile Picture

Power BI User on 06 Jul 2020 00:18:22

RE: Deployment pipelines to support dataflows

We need this to fully operationalize BI Dev with Dataflows. Otherwise we would need to create a custom way of deploying Dataflows along the development stages, really not favourable!!

Robert Power BI User's profile image Profile Picture

Debbie Edwards on 06 Jul 2020 00:17:13

RE: Deployment pipelines to support dataflows

I think this issues actually renders pipelines not useable at the moment



I have spent the last few months pushing users to move to dataflows "Power BI introduces dataflows to help organizations unify data from disparate sources and prepare it for modeling"



Everyone understands why dataflows are a good thing and have made an effort to use them.



Now everyone is excited to move to pipelines with their Premium capacity. However I've just found out it doesn't work with dataflows. Ive tried it. You get your unsupported warnings and when you look at your reports in your test environment you cant see anything even after a refresh.



Basically, I dont feel I can now backtrack on telling people that actually dataflows aren't really useable if they want to create Pipelines in their Premium capacity.



I would feel better if someone could say, this is coming in a specified amount of time. I really don't know what to tell people at the moment. they have spent a lot of time following the recommendations of dataflows.