Forum Discussion
Helper IRLS / Anonymize a certain column
How to anonymize a certain column for a certain usergroup? This is my model:
A user should always be able to see only their CostCenter. I've fixed that with an RLS function and a relationship between the tables RLS and Department [Username] = userprincipalname().
My issue is that for anyone with the flag asp_rep = 1 in my RLS-table, I need to somehow anonymize the name column in the Fact_Consultation table. I don't have a preferred method, but I'm thinking of using some sort of IF/Switch statement. However, that's where my knowledge stops. How could I achieve such a result? Data export, etc. is already limited for everyone, so it's enough if it's just a visual layer of security.
RLS-table
| CostCenter | Username | asp_rep |
| 111 | [email protected] | 1 |
| 111 | [email protected] | 0 |
| 222 | [email protected] | 0 |
Wanted result when vieing the report as a user with asp_rep = 0
| Name | Sold amount |
| Tom Hanks | 5 185 |
| Brad Pitt | 1 849 |
| Jennifer Lawrence | 19 598 |
| Emily Blunt | 17 874 |
Wanted result when vieing the report as a user with asp_rep = 1
| Name | Sold amount |
| 101 | 5 185 |
| 102 | 1 849 |
| 103 | 19 598 |
| 104 | 17 874 |
1 Reply
v-zhangtiCommunity Support
Hi, eaj
Please refer to the following links in the hopes of helping you.
Solved: Dynamic RLS - Microsoft Power BI Community
Row Level Security with SSAS Tabular Live Connection in Power BI - RADACAD
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.