Forum Discussion
Power BI Data RLS Security filter goes on and off by its own i.e. it applies some time and it doesn'
Hi AK1982 ,
How about doing like this?
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super UserHi AK1982 ,
Believe you issue is related with the relationship.
You have a many to many relationship with filter for both ways, this means that when you are maknig the look up from the user side you will get several regions for example Sam will get 4 regions however when you go to the other side from region to user if you pick up region 0204 you will get Sam and jed, this will mess up your filter and give you unexpected results.
Have you tried to make a dimension table for region to make a one to many relationship?
Hi Miguel,
Thanks for the response, I have tried with region dimension as well, but its the same issue.
Data Model now is :
Sales data table -> M:1 -> Region Dimension -> 1:M -> sales manager table.
Do I need to select "apply security filter on both directions " while joining with dimension and sales manager table?
Regards,
AK
v-lionel-msftCommunity Support
Hi AK1982 ,
How about doing like this?
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.