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 two lists
ListEmails: Email/city/country
ListSupport: Email/city/support1/support2
All people from List2 are in List1 -but not the other way.
The foreseen behaviour is that the user just opens the pBI and the system recognizes the UPN (Email) and then shows related to the city which support is available.
any ideas are welcome?
Solved! Go to Solution.
@Anonymous
You can first create a relationship between List 1 email column and list 2 email column, then create an dynamic RLS group based on the username using the list with all username.
List1[Email] = USERPRINCIPALNAME()
Final step is publish to Service and assgin users to this RLS group on PBI Service after publish.
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous
You can first create a relationship between List 1 email column and list 2 email column, then create an dynamic RLS group based on the username using the list with all username.
List1[Email] = USERPRINCIPALNAME()
Final step is publish to Service and assgin users to this RLS group on PBI Service after publish.
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
How are you showing this information? In a card visual?
You should be able to create a calculated column that uses the USERPRINCIPALNAME() to look up either email address.
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |