Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
@Aanwar0 FYI
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.
@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
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |