Forum Discussion
Dynamic RLS
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!!!
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
3 Replies
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
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
Using userpriciplename()
