Forum Discussion
RavinderSunkara
Advocate II
8 years agoDynamic 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
- RavinderSunkara
Advocate II
Team, Request your help in providing Dax query for RLS roles