Forum Discussion
Strange prefix on USERNAME() and USERPRINCIPALNAME() for external users
We are working on exposing Power BI reports to external users, so I am setting up RLS on the reports using USERNAME(). When sharing with an external test email address, I discovered that Power BI tac...
Right, this is part of the just in time provisioning of external users. The prefix is where their login is coming from. Ensures uniqueness and all that. You should expect a prefix for any supported external federated login. I think outlook.com, live.com probably some others.
Thanks Greg. Will the email always be preceded by a #? In other words, can I build a statement into RLS that removes anything before #?