Azure Analysis Services - Rolling Back Changes to Data

James H. Robinson 161 Reputation points
2020-09-17T15:46:09.997+00:00

Is there to a way to roll back changes to an AAS model after it has been processed? I don't see any references to this anywhere.

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
439 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee
    2020-09-17T22:47:52.813+00:00

    Hi @James H. Robinson ,

    Thank for you query.

    If you have your database backup before deployment, then you could probably restore it. Below is a related document just in case if you have missed it.

    Analysis Services database backup and restore

    Hope this helps.

    Thank you

    0 comments
  2. HarithaMaddi-MSFT 10,136 Reputation points
    2020-09-18T13:42:59.337+00:00

    Hi @James H. Robinson ,

    Thanks for posting the query. In addition to the approach suggested by @KranthiPakala-MSFT , the model can be connected to source-control(GIT) from Visual Studio and use a different branch for new changes. Once changes are tested, you can merge the changes to stable branch. If there is any issue in the new changes, connect to a stable branch from visual studio and deploy the old model to roll back it to old version. To enable multiple team members work on same branch, there is also an popular open source tool in Visual Studio for comparing model changes and with additional benefits - BISM Normalizer.

    Hope this helps! Please let us know for additional queries or if this does not align with the requirement and we will be glad to assist further.

    0 comments