Multiple roles for one user

[fbackes]

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? 

[Anonymous]

Hi together,

I guess there's still no other solution? I have exactly the same problem..

BR,

Sven

[v-shex-msft · Accepted solution]

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

[fbackes]

@v-shex-msft: Many thanks! I've just submitted it to the ideas forum.