Forum Discussion
RLS tabular model filter does not recognize Username()
In Visual Studio I add the filter below to the 'Staff Education Organization' Table.
It only works if I add email address directly in the filter such as "[email protected]" instead of USERNAME().
but it does not work if I use USERNAME() function.
What can be the problem?
= 'Staff Education Organization'[SchoolID] =
LOOKUPVALUE('Staff Education Organization'[SchoolID],
'Staff Education Organization'[ElectronicMailAddress],
USERNAME()
)
Model Filter
This is what we found:
Username() function is not returning clean email if email is added to AAD as a guest.
It attaches this string at the front:
live.com#
5 Replies
Hey,
maybe you have to consider that USERNAME() might return something different depending on the environment:
a) Power BI Desktop
here USERNAME most likely will return something similar to domain\accountname whereasb) Power BI Service
here USERNAME will return something like [email protected]Hopefully, this gets you an idea.
Regards,
Tom
Hey Tom,
Thank you for the answer. I deploy the model from VS to Azure and users log in from the add.powerbi.com. As I understand it right, we are using Power BI Service and Usename( ) suppose to return email address which is not working for me. Can you please explain more how to make this work, I am very new to it.
Thank you,
Julia
Hey Julia,
this article may guide you:
I think an essential part will be to add user to the Azure AD
But maybe it will be a good idea to consult your Azure AD administrator, but maybe that's you :-)
Regards,
Tom
