Forum Discussion
Ubedulla
1 year agoRegular Visitor
Need assistance when RLS is applied.
Hi, I implemented the RLS (If Manager logs in he will see his information along with his reportees). I got a requirement to identify first row should be Manager Info, Below that heading as Direct Re...
Ubedulla
1 year agoRegular Visitor
Hi,
Thanks for the responding.
I implemented the RLS and It is working fine, I have a table view in report and I need to show first row Manager information, In next row heading Direct Reportees following below I need to show all the direct reportees information as shown in the image below.
If Employee logs in RLS already showing only his own information that is fine.
Anonymous
1 year agoNot applicable
Hi Ubedulla
The visual effect you want to present cannot be achieved in Power BI.
I suggest you create different tables for managers and employees, and create relationships through the same fields. Create different RLS rules to achieve data privacy.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.