I could use help with using the USERPrincipalName and linking it to a csv file

[jrubino77]

I have a csv file that has our users email address in it plus their full name.  I want to use their login credentials email address, using the USERPrincipalName to link to the csv email address.  Doing this I can then use their full name in the role security test with sales rep. 

I searched the community and found several posts but I did not see any that directly shows how to do setup and connection/relationship to a csv file for matching email address for logging in.

Any and all help would be greatly appreciated.

Below is the CSV file.  The Name is their Full Name and the UserPrincipalName is their Email Address

Jim

[Greg_Deckler · Accepted solution]

@jrubino77 Source of data shouldn't matter. The way that this is done most of the time is to tie your user table to the rest of your data via relationships. Then you create an RLS rule on your User's table like the following:

[UserPrincipalName] = USERPRINCIPALNAME()

See this example:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Hierarchical-Row-Level-Security/m-p/...

@ me in replies.