Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi Team,
I'm trying to apply RLS using USERPRINICPALNAME() in Customers table.
User Security table looks like below....
Above security table is related with CUstomers table based on CITY column.
However, some user don't have city, I need to show all city of USA, eg: ALEX and Global means all Country.
How to setup this RLS using USERPRINCIPALNAME ?
Tried below DAX code and use this to get ouput of selected country for login_user's
You can see measure shows correct data as "Germany."UK"
But when I use this measure inside Customers table filter for Country, It not applying RLS ?
Hi @vijay27316
Thanks for reaching out to us.
please refer to this tutorial,
Row-level security (RLS) with Power BI - Power BI | Microsoft Learn
Row-level security (RLS) guidance in Power BI Desktop - Power BI | Microsoft Learn
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
104 | |
98 | |
98 | |
40 | |
38 |
User | Count |
---|---|
151 | |
122 | |
78 | |
73 | |
67 |