no response when clicking apply security filter in both direction

[foggychiu1221]

Hi guys, 

Assume I have a valid many to one relationship. 
I would like to use these two tables to set up RLS so I have wanted to select apply security filter in both direction. 
However, click the apply security filter does not return any response. 

I remembered in the old time, even sth wrong in the relationship, POwer bi still allows you to tick the box to apply security filter in both direction but returns an error. 
Now, I can't even tick that box. 

Anyone have any idea? I am frustrated

[v-easonf-msft · Accepted solution]

Hi， @foggychiu1221 @mlucking 

This is a known issue that has been submitted to PG , icm: 219092390

You can keep an eye on the status of this post:

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

A temporary solution is to install the November version of desktop. 

https://docs.microsoft.com/en-us/power-bi/fundamentals/desktop-latest-update-archive

Select the following links to download this earlier version:

• November 2020 version of Power BI Desktop - 32-bit
• November 2020 version of Power BI Desktop - 64-bit

Best Regards,
Community Support Team _ Eason

[mlucking]

did you have any luck with getting it to work?  Today when I went to click the "apply security...." box, i can't select it at all and had no issues in the past so i'm stumped.

[amitchandak]

@foggychiu1221 , difficult to say without looking at the model. Check if you able to save relation or not. Then try to edit.

Also, make the relation one-directional and Try