Same RLS for Different Page, Different Table

[PERMATA]

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.

😞 

[Anonymous]

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]

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.