Need help Workspace cloning with all it contents

[RashidSaba]

Hi,

I need help with tool, techniques or any workaround which could save me hours of effort.

I have a request at hand where the customer wants to migrate all 20 previous workspaces and all it contents to the exisitng one.

That includes all Dataflows, Datasets, and Reports and replicate it into the new workspace

Any help, guidence would be really appreciated.

Thanks

[v-echaithra]

Hi @RashidSaba ,

May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.

Thank you.

[MohdZaid_ · Accepted solution]

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:

1. 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.
2. 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.
3. 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.
4. 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!

[v-echaithra]

Hi @RashidSaba ,

Thank you @ibarrau  for your inputs.

We’d like to follow up regarding the recent concern. Kindly confirm whether the issue has been resolved, or if further assistance is still required. We are available to support you and are committed to helping you reach a resolution.

Best Regards,
Chaithra E.

[ibarrau]

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,