Forum Discussion
Need help Workspace cloning with all it contents
- 7 months ago
Hey RashidSaba ,
Currently, Power BI does not provide a built-in feature to clone or copy an entire workspace with all its contents (dataflows, datasets, reports) directly into another workspace. Migrating or replicating multiple workspaces with full content usually requires a combination of manual and automated steps.
Here are some approaches and tools that can help save time:
- Power BI Deployment Pipelines (for Premium/Embedded workspaces):
If you have Premium capacity, Deployment Pipelines let you promote content between Development, Test, and Production stages, but it doesn’t clone workspaces — it helps move updated content within a pipeline. - Third-party tools:
Tools like Power BI Helper or Power BI Management Cmdlets (PowerShell) can export reports and datasets from one workspace and help with bulk migration, but they often require scripting and manual re-connection of data sources. - Power BI REST APIs:
Using the REST API, you can automate exporting reports and datasets from the source workspace and then import them into the target workspace. This requires scripting and is best for large-scale migrations. - Manual export/import:
For reports, you can export PBIX files from the source workspace (if allowed), then publish them to the target workspace. Datasets and dataflows will need to be recreated or migrated separately.
If this explanation helped, please mark it as the solution so others can find it easily.
If it helped, a quick Kudos is always appreciated it highlights useful answers for the community.
Thanks for being part of the discussion!
- Power BI Deployment Pipelines (for Premium/Embedded workspaces):
Hi. It might depend on the licence you have. If you have capacity, it might be a good idea to integrate the workspaces with Git. Both the empty new and the one with the content. Then copy all that content in the file system from the old to the new one. Commit and push the changes. That should work.
If you don't have capacity and you can't integrate with git repo. Then consider the Power Bi Rest API. The dataflows could be tricky but I think they can be exported as json files. You might need to load them manually. About dataset and reports you can totally export them as pbix and import back to another workspace. The only scenario preventing that flow is when the dataset has configured incremental refresh or was modified with XMLA endpoint. You can use the Power Bi Rest API or the Fabric API. You can use the new microsoft sdk or an unofficial library that makes it simple for python called SimplePBI.
If everything is in the same Tenant/Organization, and those are simple reports, then you can do something simple like this: https://blog.ladataweb.com.ar/post/697833112208539648/simplepbipython-copiar-pbix-entre-áreas-de
Otherwise it might required a bit more coding skills.
I hope that helps,