Forum Discussion

vickyd's avatar
vickyd
Helper V
8 years ago
Solved

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 c...
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    8 years ago

    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,

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
8 years ago

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,