Row-Level-Security Problem

[azaterol]

Hello everyone,

I used the "row-level security" to set the Power BI file so that representative 1 can only see his sales.
However, now I have a page in the report where representative 1 can see the sales of representative 2 and representative 3.

What is the best way to proceed, because the pb-file has now been set globally so that representative 1 can only see his own.

[amitchandak]

@azaterol , Create a table with Email and what all representatives that person can see, join back with representative  dimension and allow to filter the dimension 

How to use Row Level Security (RLS): https://youtu.be/NfdIA0uS6Nk

Power BI- Row Level Security(RLS): Handle ALL, UserPrincipalName: https://youtu.be/KVLEnIUo4pc