Dynamic RLS

[Anonymous]

Hello Guys,
 I want to Set Dynamic RLS in Power BI..The Requirment is like i have sample data set like

Person	Sales
Pradnya	1000
Sam	2000
Rahul	3000

whenever Pradnya login to Dashboard she can able to see her data as well as all the sales value but other person name should be "****" please help how to do this in power bi.
I want Result like below table

Person	Sales
Pradnya	1000
****	2000
****	3000

Thank You!!!

[Thennarasu_R]

Using userpriciplename()

[v-luwang-msft · Accepted solution]

Hi  @Anonymous ,

According your descrebution,you could create masked column to achieve it,the following article could solve your question ,it tells about"One of the questions I got recently is this: “I want users to see one another’s sales information, but not to see who others are! How can I do that in Power BI?”

Doing something like above is a bit different from row-level security approaches. In this scenario, we do want the user to see other’s information, even how much sales they have made, But we do not want them to see WHO the others are.

This is more a data masking scenario than a row-level security. However, because the question often comes from the users of RLS, I explain it under that category. This blog post is about an approach for the explained scenario above.

"

To learn more details ,refer:

https://radacad.com/show-the-information-but-not-the-details-power-bi-data-masking 

Best Regards

Lucien

[amitchandak]

@Anonymous , if this is attached with the table having email  for RLS then you have a measure

if (Max(Table[email])  = userprincipalname(),Max(Table[Name]) , "****")

as we can not create a column with userprincipalname, have one id column which can be used in place on the name and a measure can be used for name