live.com# added to guest user (Userprincipalname)

[bhargavanand]

Hi,

My admin created a guest user with email as a@b.com in azure ad. Now their email became as a_b.com#EXT#@company.onmicrosoft.com.

In my power bi desktop, I want to add a role and add USERPRINCIPALNAME(). I have a master table with user mail id. My question is what email should add in my master table? In my testing, using live.com#a@b.com works fine. But I am not sure will it for other guest users as well. 

Any help please. Thanks.

[Anonymous]

Hi @bhargavanand ,

For guest users, you'll have to try using the following format:

USERPRINCIPALNAME()#EXT#

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

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