Forum Discussion
Data flow ownership
- 1 year ago
Hi NoeAv ,
Thank you for reaching out to the Microsoft Community Forum.
Please try below approaches:
1. Use a Shared Service Account (With Caution): Your idea of using [email protected] is common in practice. This approach centralizes ownership, but you’re right it introduces complications: Requires IT/security approval. Must have access to all data sources. Credentials must be managed securely (e.g., password vaults or managed identity).
Note: Best used for production-grade, shared dataflows where stability and continuity are critical.
2. Create Dataflows in a Shared Workspace with Contributor Roles: If you’re using Power BI Premium or Fabric, create the dataflows inside a shared workspace and assign the relevant team members as contributors.
Note :In this model: The workspace owns the dataflow, not an individual. Anyone with contributor role in the workspace can edit the dataflow. No need to “take over” ownership each time.
Steps: Move the dataflow to a shared workspace (or create a new one). Add team members as Contributors or Admins. Set proper data source credentials in the service once. This is the most scalable and Microsoft-recommended way.
3. Use Power BI Deployment Pipelines (Premium): If you're using Premium, you can create and manage reusable dataflows via deployment pipelines good for promoting from dev to test to prod.
Note: Move your dataflows to a shared workspace and give team members the Contributor role. This is the cleanest and most supportable method within Power BI’s governance model.
If my response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally, a 'Kudos' would be appreciated if you found my response helpful.
Thank you - 1 year ago
This is a common question/issue but unfortunately there is not a good answer to it. Currently all data flows must have a single account as an owner and only owners may edit a dataflow.
Some organizations take the approach you mentioned using a service account and sharing log-in information. This is both tedious to set up and a security threat. Maybe more importantly, it removes accountability from your engineers and analysts.
The best answer is the simplest, take the flow over when you need to. It’s tedious but the safest.
Awhile back there was an item on their roadmap to add additional owners of a dataflow but I have not seen or heard anything about that in well over a year.
Please mark this post as a solution if it helps you. Appreciate Kudos.
Option is to keep dataflows inside a shared workspace and give Admin or Member access to all team members. Then, everyone can edit without taking ownership.