Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Dynamic RLS Help

Hi All,   Im an RLS noob so to speak and trying to figure things out, so I have built a Security table something like this:   Email: Account: Region Country: [email protected] Apple EURO...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hey,

 

Sorry only getting back to this now... I modified what you suggested to fix an error about multiple values with:

 

[Account] =
IF (
LOOKUPVALUE(SECURITY[Account],SECURITY[Email],USERPRINCIPALNAME ()) <> BLANK (),
CALCULATE (
MAX ( SECURITY[Account] ),
FILTER ( SECURITY, SECURITY[Email] = USERPRINCIPALNAME () )
)
)

 

However this still not working, if the field SECURITY[Account] is blank for a user then it still basically prevents them from seeing anything at all, again the intention here is if I leave the Account field blank then that rule should NOT apply to them.

 

Thanks again for all the help to date!

 

Regards,

Anonymous's avatar
Anonymous
Not applicable
6 years ago

This has become even more critical for me to solve if possible now as I just realised an assumption I had made is wrong on RLS... I had thought if I had 3 RLS Rulesets like the above for example called:

 

Account Security

 

And another more or less identical formula but for Country Security and I put a user into both rules then it would limit the data both ways... but it appears thats not the case and when you test as someone in both rules it completly ignores BOTH rules? In Desktop anyway.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Apologies for the bump here, really need help on this!

     

    Thanks,