Forum Discussion
RLS set value - undesired behavior
I was able to partially resolve the issue by activating "apply security filter in both directions" between a bridge and dim table
That eliminates the issue for the sample file however it looks like I am out of luck for my work file because I have multiple fact tables connected through multiple bridge tables to a single dim table. I can toggle the security filter checkbox for one of the bridge tables which resolves the issue for that tables and connected data, however, it won't let me toggle security filter for all 4 bridge tables.
Edit:
Alternative workaround - add report level filter for the values that will be filtered by your role.
Don't check the "select all" box but instead manually tick each box for every value.
Yes I am running the same version 2.63.3272.40461 64-bit (Октябрь 2018)
Does the pbix file I linked to in my earlier post work properly for you with RLS? Is there any difference between your data or your RLS setup and the one I created in the pbix file?
I have reproduced the issue (not sure how to attach a file)
It occurs if there is a many to many relationship with a bridge in between
A few things:
1. Which Category field are you using in RLS? The one from the Sales table, or the one in the DimProduct table? I'm guessing the one from the DimProduct table?
2. Looks like your relationship between the Sales table and the Product key bridge is set for Cross Filter Direction = Single, does anything change if you change that to Both?
1. Yes I am using the one from DimProduct
2. No even if both relationships are set at cross filter = both, the issue persists. Also I would not be able to do that in the real file anyways since that would have created ambiguity.