Forum Discussion

Tracy000's avatar
Tracy000
Helper I
1 year ago

RLS

Hi team, I got a question about RLS would like to ask for your kind advice, thank you. Originally we have setup 1 role called Cost_AM_M1&M2, this role means user could only see Cost, can't see Re...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Tracy000 ,

 

It is often avoided to map a user to multiple roles, which can have unexpected results. Try creating a role like Cost_Rev_AM_M1_M2 for the user A.
Row-level security (RLS) guidance in Power BI Desktop - Power BI | Microsoft Learn

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum 

  • Tracy000's avatar
    Tracy000
    Helper I
    1 year ago

    Hi, thanks for your reply.
    It's hard to create 1 role for user A because his M1 access can't see revenue data, only M2 access could see revenue.