Forum Discussion

kuby72's avatar
kuby72
Frequent Visitor
5 years ago
Solved

Mismatched data from RLS role with more than on filter

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 ...
Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    5 years ago

    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.

v-janeyg-msft's avatar
v-janeyg-msft
Community Support
5 years ago

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.