Need assistance when RLS is applied.

[Ubedulla]

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 Reportees. Next all the direct reportees. 
I have Employee_ID, Full_Name, role, ect. columns. In role column we have Employee and Manager. Please suggest how to achive this requirement.

[Ubedulla]

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]

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.

[Anonymous]

Hi @Ubedulla 

For your question, here is the method I provided:

I recommend that your data format is best as follows:

Step 1:

Step 2:

Step 3: Publish to the service.

Step 4: Click (...) of the semantic model and select Security.

Step 5: Added Kiran's information.

You can share the report with Kiran or add him to the workspace, which can achieve RLS.

Row-level security (RLS) with Power BI - Microsoft Fabric | Microsoft Learn

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.