Forum Discussion
Multiple roles for one user
Hi all,
I have defined two roles, which restrict access on two different dimensions respectively. E.g. year = 2017 in the time dimension and customer = 'XYZ' in the customer dimension.
When I selected both of them in 'View as roles' I expected to see only the intersection (logical AND of both conditions from both roles) of the restricted sets, e.g. only data from customer 'XYZ' in year 2017. Instead of that, I saw all data.
How do multiple roles for one user work in general?
Hi fbackes,
>>e.g. only data from customer 'XYZ' in year 2017. Instead of that, I saw all data.
Current power bi 'AND' logic to link multiple RLS roles.
For your requirement, I think you can submit an idea to ideas forum or manually add a role with 'OR' logic for these conditions.
Regards,
Xiaoxin Sheng
3 Replies
Hi fbackes,
>>e.g. only data from customer 'XYZ' in year 2017. Instead of that, I saw all data.
Current power bi 'AND' logic to link multiple RLS roles.
For your requirement, I think you can submit an idea to ideas forum or manually add a role with 'OR' logic for these conditions.
Regards,
Xiaoxin Sheng
Anonymous: Many thanks! I've just submitted it to the ideas forum.
