Forum Discussion

MIkkelHyldig's avatar
MIkkelHyldig
Helper II
3 years ago

RLS multiple usernames

Hi all, I have two tables with a both ways security connection (1-* with Store column as key), where I want to setup a new RLS logic / rule. The rule should filter so the UserPrincipalName can onl...
Need Help
MIkkelHyldig's avatar
MIkkelHyldig
Helper II
3 years ago

Hi AllisonKennedy ,

Thanks for your answer. 

In Power automate I need to provide a Identity Username in RLS Role Item in action "export to file for PBI reports" and it only seems to work when one Username has one Store. However when a user has multiple stores and needs an exported report for each store I need unique users hence using a new Key-column for RLS. Now, the user [email protected] gets a report for store 7068 three times instead of 7068, then 1001 and then 1002 in three different exported reports. 

Thats why I wanted to create, in this example, three unique rows for each store by using three different users: M[email protected], [email protected] and [email protected]. But I dont know how to handle multiple users in UserPrincipal logic for RLS. 

Does it makes sense? 

Thanks,

AllisonKennedy's avatar
AllisonKennedy
Community Champion
3 years ago

I haven't used that action in Power Automate but am looking at it now: 

 

 

 

Assuming you can provide the 'identities username' value into PowerAutomate that matches the key, the RLS DAX should be simple
Table[Key]  = UserPrincipalName()

 

If I'm undestanding correctly??