Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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:
@ me in replies.
@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:
@ me in replies.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
2 | |
2 | |
1 | |
1 |