Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
vijay27316
Frequent Visitor

RLS DAX - HELP

Hi Team,

 

I'm trying to apply RLS using USERPRINICPALNAME() in Customers table.

User Security table looks like below....

vijay27316_1-1672261612863.png

 

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 ?

vijay27316_0-1672261593776.png

 

1 REPLY 1
v-xiaotang
Community Support
Community Support

Hi @vijay27316 

Thanks for reaching out to us.

please refer to this tutorial,

Row-level security (RLS) with Power BI - Power BI | Microsoft Learn

vxiaotang_1-1672309892747.png

Row-level security (RLS) guidance in Power BI Desktop - Power BI | Microsoft Learn

vxiaotang_0-1672309826697.png

 

 

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.

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.