Azure Analysis Services: How to add Role Members to Models?

Question

Hi all,

I'm a bit stuck with this part of my Azure AS journey. Any help is greatly appreciated.

I have a model that I have built out in Visual Studio and I am successfully deploying to Azure AS. I am now trying to add my power users to give them access to the model.

I can add a Role in Visual Studio and deploy that, however I am unable to add members to that role, the following error is presented when I try and add any members to the role. I am able to search for users & groups successfully, both in Azure AD and on-prem AD, however it does not let me save the role with any members added to the role.

If I save the role (with no members) and deploy to Azure AS, I am then able to connect to AS with SSMS and add members to the role. However this is not ideal as the members are removed every time I deploy the model again from Visual Studio.

What am I missing here?

============================

Error Message:

Failed to save modifications to the server. Error returned: 'ID cannot be specified for Azure Analysis Services role member: '<pii>obj:a23c838a-ef37-4eb2-9036-xxxxxxxxxxxxxxxx@d1fd0900-4563-xxxxxxxxxxxxxxxx</pii>'.

Technical Details:
RootActivityId: 97dc9e09-664f-xxxxxxxxxxxxxxxx
Date (UTC): 9/30/2020 10:55:37 PM

'.

Failed to save modifications to the server. Error returned: 'ID cannot be specified for Azure Analysis Services role member: '<pii>obj:a23c838a-ef37-4eb2-9036-xxxxxxxxxxxxxxxx@d1fd0900-4563-xxxxxxxxxxxxxxxx</pii>'.

Technical Details:
RootActivityId: 97dc9e09-664f-xxxxxxxxxxxxxxxx
Date (UTC): 9/30/2020 10:55:37 PM
'.

============================

Call Stack:

at Microsoft.AnalysisServices.BackEnd.DataModelingSandboxTabular.ExecuteEngineCodeInBackground(OperationType type, Boolean cancellable, AMOCode code, Boolean raiseEvents)
at Microsoft.AnalysisServices.BackEnd.DataModelingSandboxTabular.DoExecuteEngineCode(OperationType type, OperationCancellability cancellable, AMOCode code, Boolean raiseEvents)
at Microsoft.AnalysisServices.BackEnd.DataModelingSandbox.ExecuteEngineCode(OperationType type, OperationCancellability cancellable, AMOCode code, Boolean raiseEvents)

at Microsoft.AnalysisServices.BackEnd.DataModelingRoleTabular.Update(DataModelingSandbox sandbox, String name, String description, IEnumerable1 roleMembers, DataModelingRolePermission permission, Dictionary2 tableDaxPairs, Dictionary`2 rolePermissionChanges)

at Microsoft.AnalysisServices.BackEnd.DataModelingRoleTabular.Update(DataModelingSandbox sandbox, String name, String description, IEnumerable1 roleMembers, DataModelingRolePermission permission, Dictionary2 tableDaxPairs, Dictionary`2 rolePermissionChanges)
at Microsoft.AnalysisServices.Common.RoleManagerDlg.SaveChanges()

============================

Answer 1

Hi @Me At Worky ,

Welcome to Microsoft Q&A platform and thanks for using this forum.

Firstly sorry for the delay in my response.
Could you please check what is the workspace of the Tabular Analysis Services project from SSDT? If it is AAS workspace server there could be a problem with AAD users because of a limitation with SSDT. If that is the case to resolve the issue could you please try using Integrated workspace while opening the model in the Visual Studio.

To get more information related to workspace management, please refer to this doc: https://learn.microsoft.com/analysis-services/tabular-models/workspace-database-ssas-tabular?view=asallproducts-allversions.

Hope this info helps. Let us know how goes.
Thank you