Using Username() in DAX with Row-Level Security

Yes, the user has to be logged in for row level security to apply at the user level.  Take a look at this article on dynamic rls.

https://docs.microsoft.com/en-us/analysis-services/tutorial-tabular-1200/supplemental-lesson-implement-dynamic-security-by-using-row-filters

Hi. Your question is not quite clear but let me try. Yes they have to login.

In order to use RLS in a report, all the users accessing to this report must have a pro account (or premium capacity and any account). When the login in the platform with their own professional account, the USERNAME() will resolve finding the email.

Regards,

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