Forum Discussion
Solved
RLS not working for only one table
Hi! I created RLS for several tables in my report, all following the same code (except for the last part where I change the respective table reference). This is the code: var _User = USERPRINCIPAL...
I managed to solve this issue by doing a workaround because for some reason RLS doesn't seem to work with bidirectional many-to-many relationships. That was the problem. So to "solve" this, I needed to create a bridge table with two columns: one for the distinct ID that would relate to all the other tables, and another for the RLS Code. Then I applied RLS only to this bridge table, and it worked.
Hi nok ,
I wanted to follow up on our previous suggestions. We would like to hear back from you to ensure we can assist you further.
Thank you.