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.
Greeting ,
im kinda new to Power BI , im trying to add roles in my project , So to make it simple for you to understand what im trying to make i will share a little example of what im doing.
im working with HR data , i got 2 roles : HR director and talent developer . what im trying to achieve that when an HR director connect to the application i want him to see only the offers related to his branch ( i have a field named Branch ) any trick of how to add this in my project and if there is a documentation i can follow !
Thanks in advance
Solved! Go to Solution.
HI @Ramyzo ,
You can refer to the below link to know how to create RLS role based on username.
You can create a user mapping table to map username and user role, then you can find out correspond user role based on current user name and apply RLS filter on user role field to enabled filter effect. (these filter effect will apply to other tables by relationship keys)
Regards,
Xiaoxin Sheng
HI @Ramyzo ,
You can refer to the below link to know how to create RLS role based on username.
You can create a user mapping table to map username and user role, then you can find out correspond user role based on current user name and apply RLS filter on user role field to enabled filter effect. (these filter effect will apply to other tables by relationship keys)
Regards,
Xiaoxin Sheng
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |