Forum Discussion
SSAS Row-Level Security not working
Hello, I am stumped on this one so would really appreciate some help. We have a SSAS Tabular Model on an on-premise server which is used for Reports on the Power BI Service, with the appropriate gate...
It seems this issue may have stumped the forum as well as myself! A MS support ticket may be in order.
Update: For anyone in the future who happens to have this exact problem, the solution was to remove the users from ALL other roles in the data model, including roles which have been de-activated or set to 'no access'. Membership of such a role, even if set to 'no access' at an overall level, can override RLS in any other active or non-active role the user is a member of. This is in contrast to OLS, where membership of a deactivated or 'no access' role does not appear to override OLS in an active role.