cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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

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

Users csv file.PNG

Jim

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IV
Super User IV

@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.


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

1 REPLY 1
Highlighted
Super User IV
Super User IV

@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.


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors