When dashboards are published to Tableau Cloud, the function USERNAME() returns the user's Tableau Cloud username, which is the email address associated with their Tableau Cloud account.
Tableau documentation states:
* On Tableau Cloud, the value returned by USERNAME() is always the user's email address.
* Row-Level Security (RLS) is typically implemented using a comparison of USERNAME() to an email field in the data source.
* For secure filtering, the field compared to USERNAME() must match the authentication identity exactly.
Looking at the provided table:
* "Abbreviated Name" contains short custom codes like "SMiller," which do not match Tableau Cloud usernames.
* "Lower Case Name" contains names like "sean miller," which also do not match Tableau Cloud usernames.
* "Email" contains the full email address for each user, such as "[email protected]," which is the only field that corresponds to what USERNAME() returns in Tableau Cloud.
Therefore, the correct field to reference is Email.
* Tableau Cloud authentication documentation stating USERNAME() returns the user's email address.
* Row-Level Security setup guidance recommending the comparison USERNAME() = [Email Field].
* Tableau security practices indicating only the email column will match USERNAME() values on Tableau Cloud.