Unable to tick "apply security filter in both directions"

[Anonymous]

Hello,

I just started working on RLS, when I have encountered this issue below. I am not able to tick the "apply security filter in both directions" check-box in relationship editorial. I don’t have it enabled anywhere else, so I got very suspicious. Can it be somehow related to DAX studio or Table Editor that I have been messing around? Can I perhaps first disable and then enable this feature to work for this specific Power BI-file? Is there another way to apply security filter in both directions?

I can post more details, if needed. Thank you in advance & Merry Christmas!

[Anonymous]

@amitchandak  thank you for quick response. It helped a lot. On the other hand, I heard that it is possible to rewrite the security bi-directional filter as "Table filter DAX " expression.

I came up with this expression, in case somebody else was thinking the same. In my case:

[sys_idKey] IN SELECTCOLUMNS(
FILTER(
'Group Members',
[Email]=USERPRINCIPALNAME()
),
"cmdb_ci.sys_idKey"
,[cmdb_ci.sys_idKey]
)

With some help from Reza: https://radacad.com/dynamic-row-level-security-with-profiles-and-users-in-power-bi

BR,
Anton

[amitchandak · Accepted solution]

@Anonymous , These is an issue reported on Dec-2020 release. Please check update and vote

https://community.powerbi.com/t5/Issues/Apply-security-fillter-in-both-direction-not-usable-after/idi-p/1554852