How can I copy and duplicate an AAS cube?

Question

We an Azure Analysis Services Tabular model which pulls from our Azure Synapse database. We want to create a duplicate of this cube with the exact same measures, calculations, etc. so that we can add tables that we don't want to add to the original one. Is this possible? If so, how can we go about doing this? Currently we are using Visual Studio to do development in the tabular model.

Answer 1

Hello @amzzz ,

Thanks for the question and using MS Q&A platform.

Please correct me if my understanding is incorrect. You want to know if there is any way to duplicate an Azure analysis services cube with the same measures, calculations, etc

You can achieve this by using backup restore options available in AAS.

steps:

1. Configure storage settings
2. backup the cube to the storage account location
3. restore the cube with a different name(as you wants a duplicate cube here) from the storage location

This document explains the backup and restore process in AAS. Please go through it and let us know if you have any further questions.

---

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
  • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

Answer 2

If you dont want to copy it daily, you could simply deploy it from your VisualStudio a second time with a new Target. Everything else would then be identical ...
You can create two configurations in VisualStudio to easily switch between the two cubes ...