I have a very simple tabel with some rows that have an email address as one of the columns. For each email address there are several mathing rows. There is nothing else in the model. Setting up RLS with a fixed value works fine, I can test in desktop (=OK), i can publish to service and assign role (=OK).
But when I change the fixed value to a dynamic one (USERNAME() or USERPRINCIPALNAME()) it does not work anymore. I have measures showing me the values of these functions and they are equal to the values I have in the above table. I can even test for equality in a measure and get a TRUE for relevant rows. But still filter is not applying, not with View as in desktop and not in service either. With one exception though, when I change the email address in some of the rows to "DESKTOP- ..." (whatever the default value in PBI Desktop) it works fine when I view as Role (of course, not in service).
Pretty sure I am missing something really silly, but completely stuck.
