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.
Hi,
Is it possible to use different Roles in Power BI Embedded for RLS? for example: on some of our reports we want RLS to apply on OrganisationId and for some reports we want RLS to apply on UserId. Maybe this is possible based on a role name?
Thanks in advance.
Solved! Go to Solution.
HI @rolf1994,
You can link user table and organisations table, then turn on the 'apply security filter in both directions' option and modify the 'cross filter direction' option to 'both' at manage relationships.
Then create two roles(one on organisation id, another based on user id), setting the specific one to users who needed.
Regards,
Xiaoxin Sheng
HI @rolf1994,
You can link user table and organisations table, then turn on the 'apply security filter in both directions' option and modify the 'cross filter direction' option to 'both' at manage relationships.
Then create two roles(one on organisation id, another based on user id), setting the specific one to users who needed.
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |