Static RLS Filtering Multiple Fact Tables

[crisher]

Hello, we are trying to use a single dimension table with RLS to filter multiple fact tables. It worked previously, and we have a model that it still works in. However, everything looks the same from a relationship perspective. Many-to-many bidirectional security filter is not enabled. Here is a video explaining what we are seeing.

https://easierway-my.sharepoint.com/:v:/g/personal/crisher_1path_com/EWbKdrbeVEtGkvsAqWfNcwkBM2MlB2b...

@Aanwar0 FYI

[crisher]

Sorry, I never came back to this. We found an underlying issue with inbound data and relationships.

And, we are definitely aware that the model is far from ideal. Inherited it. Likely going to completely re-write this in the very near future.

[amitchandak]

@crisher , I see three tables related to many to many bi-directional joins, Not an ideal model.

Many to many fine if those two tables using RLS using user.

Can you share  a sample pbix after removing sensitive data.

refer if needed

How to use Row Level Security (RLS): https://youtu.be/NfdIA0uS6Nk