RLS DAX - HELP

[vijay27316]

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 ?

[v-xiaotang]

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.