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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
vickyd
Helper V
Helper V

Setup Row level security on multiple dimensions

I'm unable to figure out how to setup row-level security on multiple dimensions for a model as described/shown below. 

I've tried to provide as much detail as possible with sample data that pretty closely represents the actual model. I know how to setup dynamic security for just the Org piece but both the Org and Project is where I'm struggling.

 

Would appreciate any guidance on how I could make it happen. 

 

RLS.png

 

Here's a link to a sample model I created in Power BI -> https://file.io/Ty9Nem

1 ACCEPTED SOLUTION
v-sihou-msft
Microsoft Employee
Microsoft Employee

@vickyd

 

No, it's not possible to achieve this kind of RLS. We can only apply dynamic row level filter to limit access based on "1 to 1" mapping which can be achieved with LOOKUPVALUE(). However, we can't have this dynamic security across more than two tables. 

 

For example, you can get the Org ID based on accessing user. Then you can still get another column value with LOOKUPVALUE() based on these "filtered" Org ID. But you can't go any further to map next column. 

 

Regards,

View solution in original post

1 REPLY 1
v-sihou-msft
Microsoft Employee
Microsoft Employee

@vickyd

 

No, it's not possible to achieve this kind of RLS. We can only apply dynamic row level filter to limit access based on "1 to 1" mapping which can be achieved with LOOKUPVALUE(). However, we can't have this dynamic security across more than two tables. 

 

For example, you can get the Org ID based on accessing user. Then you can still get another column value with LOOKUPVALUE() based on these "filtered" Org ID. But you can't go any further to map next column. 

 

Regards,

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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