Mismatched data from RLS role with more than on filter

[kuby72]

Hi,

I would like to ask you to help me understand behavior of RLS in Power BI. I have 3 facts tables (in direct query mode) and 4 Dim tables. I have to provide for users role which is unifying data where user assigned to the role (USERPRINCIPALNAME() ) can see union of data filtered by each dimension rls filter. Here are printscreen of my model and printscreen of my RLS role.

One dimension is filtering business segment of sales, second product segment of sales and 3rd on is filtering sales people and each dimension table i can use in RLS DAX with UPN.

Using all three conditions is returning mismatched unexplainable rows. Using two of filters is retrurning almost all rows. using one filter is returning correct data.

Is there any way how to union all three filter in one role?

[v-janeyg-msft · Accepted solution]

Hi, @kuby72 

According to your description, I think you can try to create a general user table, then create a relationship with the three fact tables, and finally set RLS in the general table.

Reference: https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls 

If you still need help, please feel free to ask me.

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.