Powerbi Service: Test as role does not work properly when userprincipalname is different then e-mail

[KarolDmo]

Powerbi Service: Test as role does not work properly if userprincipalname is different then e-mail.

In our company we have guest accounts, who use their own emails to login. 

In AAD Email is for instance: jb@spar.dk but userprincipalname is : jb_spardk#EXT#@sdconline.onmicrosoft.com

In Security table email is jb@spar.dk , using RLS in Powerbi compares it and user has access - which is correct.

However when developer wants to test, select: test as role, then he cannot see data, unless we change security table e-mail address from  jb@spar.dk to jb_spardk#EXT#@sdconline.onmicrosoft.com. But then real user cannot see data.

It's not a big bug, but it makes not possible to test RLS for Guest accounts 

Best ,

Karol Dmochowski 

@Anonymous 

[v-yingjl]

About external users with row-level-security, you can refer the below thread which introduces it in details:

https://community.powerbi.com/t5/Service/RLS-for-External-guest-users/m-p/2670432/highlight/true

Best Regards,
Community Support Team _ Yingjie Li

[KarolDmo]

Thank you for providing link to thread with details. 

So it works as I have explained, but still what is not correctly working is testing. When developer use powerbi service and 'test as user' a dataset, then it will not see data for a specific guest (EXT) user, eventhough when guest user login he can see data (which is correct)