Forum Discussion

RavinderSunkara's avatar
RavinderSunkara
Icon for Advocate II rankAdvocate II
8 years ago

Dynamic Row Level Security (RLS) in SSAS Tabular cube for Power BI Report

We have defined 3 roles in SSAS Tabular Cube 1-role) Admin 2-role) StandardUser 3-role) SuperUser. I am included in all the 3 roles. In the power bi report server StanderdUser is working fine by giving limited access to the data. Could you please let me know if I login as Admin it should by-pass StandardUser & SuperUser and show me logged in as Admin using DAX Query or any other suggestions if possible. Also we want to show a message to the users when the user logins in it should show the message that you are a Admin or standarduser or superuser.

1 Reply