Forum Discussion
RLS set value - undesired behavior
Hi
I thought I had RLS figured out but I am just puzzled here
I have some sales connected to a Product dimension table with a Category column (A, B, C etc)
I have created a role with the only filter being applied to the Category column where [value] = "C"
Without the role active, here is what I see on a new report page
also here is a snap of the page level filter for the Categories
If I apply the role I see this
As you can see the table on the left got filtered correctly and is only showing C, however, the total value on the table as well the visual on the right remains unfiltered.
In addition, the page level filter now only lists C as an available option and it remains unchecked. If I do check it then everything filters correctly.
After some tinkering I discovered that if I manually select each category on the page level filter before applying the role
than when I do apply the role it works as intended
Can someone explain to me what is going on here? Am I doing something wrong?
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.
11 Replies
- ssugarResolver III
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)