Role updates remove existing role members

[kakasnest]

In the options menu the "Include roles" option is responsible for comparing role differencies.

It has a suboption toggle "For role updates, retain members".

In version 5.1.7, irrespective of this suboption toggle setting, role members are deleted if they exist in the target.

(Version is important, since the 5.1.12 is in pre-release phase and 5.1.11 doesn't allow connection to other tenants besides the current user's tenant.)

[christianwade]

Thanks for raising this. Will look into it, but I have a few questions please:

Are you saying:

1. This issue doesn't occur in 5.1.11 and above because doesn't allow connection to other tenants besides the current user's tenant, and
2. The issue is limited to cross tenant/B2B comparisons
   ?

[kakasnest]

Sorry, I wasn't clear with my issue raise.

I was also the person, who raised one of the issues about not having a Windows pop-up when comparing in 5.1.11.

I only specified I use 5.1.7 because I have no idea if the 5.1.11 version solved this and I haven't tried with 5.1.12-PreRelease yet.

But given that 5.1.7 deleted all the role members on one of our dataset in our own tenant with the retain setting on, I believe this is not necessarily related to the other issue.

To recreate the same scenario I only had to

• open ALM Toolkit
• enable the retain role setting
• compare my local (source) and cloud dataset (target)
• check if there are any role changes where the role members would be removed on update.

I just hope I am not creating an issue that has been solved in later versions already.

[christianwade]

I think I found the issue & fixed in https://github.com/microsoft/Analysis-Services/releases/tag/5.1.15-PreRelease
Thanks for raising

[christianwade]

Included in prod release: https://github.com/microsoft/Analysis-Services/releases/tag/5.1.20