Azure Analysis Services - Rolling Back Changes to Data

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

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.
337 questions
{count} votes

2 answers

Sort by: Most helpful
  1. answered 2020-09-17T22:47:52.813+00:00
    KranthiPakala-MSFT 32,896 Reputation points Microsoft Employee

    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

    No comments

  2. answered 2020-09-18T13:42:59.337+00:00
    HarithaMaddi-MSFT 10,071 Reputation points

    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.

    No comments