test role rls guest user

[Anonymous]

Hi, 

I am trying to test role rls for guest users and nothing happens in test as role.
Is it correct that it is not possible to test rls for guest users???

[v-yangliu-msft · Accepted solution]

Hi  @,

Guest user： abc@domainName.com

Whether the value in the table is abc_domainName.com#EXT#@ourOrganization.onmicrosoft.com data.

abc@domainName.com , only data that belongs to the rows fully matched with this value will be displayed for him,  If there is a row whose value is abc_domainName.com#EXT#@ourOrganization.onmicrosoft.com, it won’t be displayed for the user  abc@domainName.com

So, guest users email for abc@domainName.com, not abc_domainName.com #EXT#@ourOrganization.onmicrosoft.com then you could take it as UPN.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AnkitKukreja]

Hi! @Anonymous 

To test the RLS role you need to use the same ID that is being used by the guest user to log in. I haven't tested it that way but I expect it should work.

Or you can use this approach https://docs.microsoft.com/en-us/power-bi/guidance/whitepaper-azure-b2b-power-bi

[Anonymous]

I guess/hoping that using normal email works fine RLS eventhough its not possible to test it?

[Tutu_in_YYC]

How did you set the RLS up and how did you test it?