Forum Discussion

PERMATA's avatar
PERMATA
Frequent Visitor
2 years ago

Same RLS for Different Page, Different Table

Hi Everyone,

 

Please kindly help on this.

 

I have successfully create a dynamic RLS for 1 page (Page 1/Sheet 1) which consist of join of User_Table, Data_Table_A

 

,but the RLS does not work when I use the same User_Table for second page (Page 2/Sheet 2) which link to Data_Table_B

 

I have do the check by create a new sheet to check whether the join of User_Table X Data_Table_B is work, and yes it works, when I try to click one user in User_Table, the Data_Table_B is filtered correctly, but when try to use view as Roles, it did not work.

 

😞 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi  PERMATA ,

     

    Ensure that the table relationships are set up correctly. You can manually enable bi-directional cross-filtering with row-level security by selecting the relationship and checking the Apply security filter in both directions checkbox.

    You can check the restrictions of RLS in the following official documentation:

    Row-level security (RLS) with Power BI - Microsoft Fabric | Microsoft Learn

     

    Best Regards,

    Liu Yang

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

    • PERMATA's avatar
      PERMATA
      Frequent Visitor
      2 years ago

      Hi Liu Yang,

       

      The relationship of the table is many-to-many for my case, and if I check 'Both' in Cross Filter Direction, the OK button is not visible.