Forum Discussion

AK1982's avatar
AK1982
Frequent Visitor
6 years ago
Solved

Power BI Data RLS Security filter goes on and off by its own i.e. it applies some time and it doesn'

Hi,   I have an RLS filter applied between the sales table and sales manager table, this filter works some times and fails sometimes, the sales manager should only see data for a specific region. ...
Need Help
Show and Tell
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    Hi AK1982 ,

     

    How about doing like this?

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

AK1982's avatar
AK1982
Frequent Visitor
6 years ago

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-msft's avatar
v-lionel-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi AK1982 ,

 

How about doing like this?

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.