Forum Discussion
bekkac579
1 month agoFrequent Visitor
Take over ownership of Dataflow Gen1 with REST API?
We have a lot of PBI Gen1 dataflows in our Fabric workspace which are owned by a colleague who will soon be leaving the company. We are looking for a way to use the Power BI API to transfer ownershi...
- 1 month ago
Hi bekkac579
Thanks for raising this you've analysed it correctly. Power BI Dataflows Gen1 does not currently expose a public "Take Over" REST API like semantic models do, and Update Dataflow can't be used since it requires existing ownership.The supported workaround we usually recommend is Export -> Import as the new owner:
- Export the dataflow definition (as admin or current owner):
GET https://api.powerbi.com/v1.0/myorg/groups/{workspaceId}/dataflows/{dataflowId}This returns the model.json.
- Import it while authenticated as the new owner (user or service principal):
POST https://api.powerbi.com/v1.0/myorg/groups/{workspaceId}/imports?datasetDisplayName=model.jsonThe identity making this call becomes the new owner.
-
Reconfigure credentials and refresh schedule, then delete the original dataflow.
A few practical tips:
- The new dataflow will have a new ID, so update any linked dataflows or semantic models that reference it.
- We strongly recommend transferring ownership to a service principal or shared service account to avoid this situation recurring when team members change.
- For bulk migration, this can be scripted in PowerShell or Python by iterating over GET /groups/{workspaceId}/dataflows.
Best Regards,
Cheri Srikanth
CST Team. - Export the dataflow definition (as admin or current owner):
bekkac579
1 month agoFrequent Visitor
Thanks this is helpful. We have just done it through UI but good to know this is an option.