Forum Discussion
Resolve issue with username data for RLS
Trying to implement RLS for a report. The user name data in the data set is only "Firstname Lastname". Using USERNAME() won't help as it returns the domain\logonname, which the logonname won't be t...
breben for the xls and it will pass it on to your connected table. You can check RLS-related videos on my channel just to get a basic understanding of where to apply the role
I'm still struggling on the DAX portion. The native UserName() and UserPrincipalName() functions won't work since my dataset only has the user's full name (Joe Smith) and neither username or UPN in this scenario contain the full name, only an abbreviation of their full name ([email protected]). I have an XLS where I have defined the user's full name and the related UPN and have created the relationship to the database dataset but still struggling on how to implement this lookup in the report.