Need Help on RLS

[Krushnab_85]

 I have three tables, i.e Center, Contacts, Interaction... Center is filtering Interaction Table and other table as well... Contacts is also filtering Interaction. There is no connection between Interaction and Center... I am adding RLS table to filter Center table for getting accurate results across the models...and its giving.. but there is one visual from which uses contacts table .. thats why i am not able to filtering the data till anyone select the slicer ..
Any solution on this?

[v-sdhruv]

Hi @Krushnab_85 ,
Just wanted to check if you have resolved the issue.
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You

[v-sdhruv]

Hi @Krushnab_85 ,
Just wanted to check if you have resolved the issue.
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You

[v-sdhruv]

Hi @Krushnab_85 ,
Just wanted to check if you have resolved the issue.
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You

[Anonymous · Accepted solution]

Hi @Krushnab_85 ,

Based on your description, the issue is that the Contact table is not affected by the RLS configured on the Center table. I suggest you check the relationship between the Center table and the Contact table and make sure the relationship is active. If I misunderstood, please provide to more details like screenshot, table relationship model.

——————————————————————————————————————————————————

If my answer helps you solve the problem, please accept my answer as a solution and let it be seen by more people in need.

Best regards,

Mengmeng Li

[amitchandak]

@Krushnab_85 , Try making both the joins bi-directional