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.
I'm not able to reproduce your issue.
I've created a pbix file with the same data as yours, but mine is filtering correctly when applying RLS:
https://github.com/ssugar/PowerBICommunity/raw/master/community-sol-561821.pbix
Could you make sure your running the latest version of Power BI Desktop?
Version: 2.63.3272.40461 64-bit (October 2018)
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?