Home Azure Analysis Service ID cannot be specified for Azure Analysis Service role member
Post
Cancel

Azure Analysis Service ID cannot be specified for Azure Analysis Service role member

After trying to configure Role Level Security as described in the following article:

https://docs.microsoft.com/de-de/power-bi/desktop-tutorial-row-level-security-onprem-ssas-tabular

We experienced the following issue when we were trying to add any Azure AD user.

1
ID cannot be specified for Azure Analysis Service role member: user@domain.com

The solution was to switch to Integrated workspace and to deploy the model again. https://docs.microsoft.com/en-us/analysis-services/tabular-models/workspace-database-ssas-tabular

Also make sure, when you want to use Azure AD as Identity Provider, that the user is in the format user@domain.com and use Add External

https://docs.microsoft.com/en-us/azure/analysis-services/analysis-services-database-users#to-add-or-manage-roles-and-users-in-visual-studio

This post is licensed under CC BY 4.0 by the author.