Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello,
I would have a question about using Deployment Pipelines together with Dataflows.
General:
In our company, we are using Dataflows to supply any kind of data that has a database-like source system. We are storing those dataflows in exclusive workspaces that only contain dataflows, not any reports or dashboards. Only certain creators have access "Viewer" access to these Dataflow-workspaces to built their reports based on them.
Afterwards, they store their reports in dedicated workspaces that are intended only for sharing reports, dashboards, etc. Those workspaces on the other side do not contain any dataflow. We clearly separate Dataflows and Frontends in this way.
Now, we planned to use the Deployment Pipelines to have the classic DEV / TEST / PROD staging process in the report development process.
1. We imagined to have a report being stored on a workspace that is assigned to Development in Deployment Pipeline. The report is connected to a Dataflow that has a DEV source system (Dataflow stored in a different workspace then the report).
2. After the report is finished it should be promoted to next stage --> Test in Deployment Pipeline. At deployment of the report from Development to Test, automatically the source of the report changes to another dataflow, which isconnected to a QUAL source system ((Dataflow stored in a different workspace then the report).
3. Finally, in the third stage, the report should be automatically connected to the dataflow that goes to the Productive system, during deployment process ((Dataflow stored in a different workspace then the report).
Is something like this possible with Deployment Pipelines or isn't this the intention of it?
Some hints or guidance would be great, I wasnt able to make it work. It somehow doesnt allow me to set "Rules" whenever there is a report involved that is connected to a dataflow.
Best Regards,
Johann
If you have your dataflows setup in a pipeline (dev->test->prod) and your reports in a separate pipeline, when you deploy your reports, the pipelines should autobind to the dataflow in the corresponding stage of their pipeline.
Please see: https://learn.microsoft.com/en-us/fabric/cicd/deployment-pipelines/understand-the-deployment-process...
Hello blopez11,
I tried to do as you suggested, but it wasnt working. Maybe I explained my case wrong.
We have the following situation:
Dataflows
"Sales Data Dataflow - Test" (Located in Workspace "Sales Data Test Dataflows")
"Sales Data Dataflow - Prod" (Located in Workpsace "Sales Data Prod Dataflows")
Reports
"Sales Data Report - Test" (Located in Workspace "Sales Data Test Reports") --> Connected to dataflow "Sales Data Dataflow - Test"
"Sales Data Report - Prod" (Located in Workspace "Sales Data Prod Reports") --> Connected to dataflow "Sales Data Dataflow - Prod".
Now I have setup one deployment pipeline for the dataflows and another pipeline for the reports (both pipelines have stages Test and Prod).
I started the deploy of dataflows in the dataflow pipeline from Test to Prod. When I move the report in the report pipeline from Test to Prod, the dataflow that its connected to, does not change automatically to the dataflow Prod in the report.
Thank you
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!