Solved: Setup Row level security on multiple dimensions

vickyd · ‎12-18-2017

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.

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

v-sihou-msft · ‎12-25-2017

@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

v-sihou-msft · ‎12-25-2017

@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,