Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
95 | |
75 | |
71 | |
65 |
User | Count |
---|---|
140 | |
109 | |
103 | |
82 | |
73 |