Forum Discussion
Solved
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(). bu...
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#
Thank you for the useful article, Tom
I have two emails added to Azure.
The first email is my work account and it’s not an Admin for AAD/Azure, but it IS an Admin (“Owner”) for all the associated resources. So I guess the firsl email will not work for testing.
The second email is added as a guest account.
Whould RLS work on the second email?
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#