Forum Discussion

Ramyzo's avatar
Ramyzo
Helper II
6 years ago
Solved

How to add Roles

Greeting  ,    im kinda new to Power BI , im trying to add roles in my project , So to make it simple for you  to understand what im trying to make i will share a little example of what im doing.  ...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    6 years ago

    HI Ramyzo ,

    You can refer to the below link to know how to create RLS role based on username.

    RLS with UserName() 

    You can create a user mapping table to map username and user role, then you can find out correspond user role based on current user name and apply RLS filter on user role field to enabled filter effect. (these filter effect will apply to other tables by relationship keys)
    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI Ramyzo ,

You can refer to the below link to know how to create RLS role based on username.

RLS with UserName() 

You can create a user mapping table to map username and user role, then you can find out correspond user role based on current user name and apply RLS filter on user role field to enabled filter effect. (these filter effect will apply to other tables by relationship keys)
Regards,

Xiaoxin Sheng