Row Level Security: DAX Filtering other than username()

Hi nencarnacion,

The email address should be an attribute of the AD user account, known as UPN. For the accounts that didn't have this attribute, I don't think Username () function and RLS would work properly for those accounts.

Check the blog below for some details:

Using Username() in DAX with Row-Level Security

And: Row-level security (RLS) with Power BI

Your requirements should be similar to the following idea:

Assign USERNAME() to parameter of a SQL function data source

SQL server security only recognize the format of DOMAIN\username , please vote it if this is helpful. Or you may consider submit your idea on this aspect.

Regards