Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have an application which is intended for a user to few ALL of a redacted Asset table, as well as a filtered view of their own data Asset RLS. This would allow benchmark comparisons of filtered vs whole. RLS is working by filtering at the user level as intended. It appears that it also propagates to the Asset table by virtue of a connection to a common table Asset Health (lots of measures).
I am looking for a way to avoid RLS filtering to the Asset table, want only the result highlighted in yellow.
Solved! Go to Solution.
Filters applied to the Asset RLS table are not propagating to the Asset table as the 1:many relationship between Asset and Asset Health is not bidirectional. What leads you to think that it "appears that it also propagates"? Can you post your RLS DAX expression?
You can indeed implement partial RLS with a model design similar to yours:
https://docs.microsoft.com/en-us/power-bi/guidance/rls-guidance#design-partial-rls
Filters applied to the Asset RLS table are not propagating to the Asset table as the 1:many relationship between Asset and Asset Health is not bidirectional. What leads you to think that it "appears that it also propagates"? Can you post your RLS DAX expression?
You can indeed implement partial RLS with a model design similar to yours:
https://docs.microsoft.com/en-us/power-bi/guidance/rls-guidance#design-partial-rls
I agree, digging deeper, the problem is that the filter into Asset Metrics means the data I wanted to summarize from the non-RLS table Asset is getting filtered. Now that I see it? Obvious. I need to re-think. Thanks for the assist.