Hi @HamidBee ,
By default, row-level security filtering uses single-directional filters, regardless of whether the relationships are set to single direction or bi-directional. You can manually enable bi-directional cross-filter with row-level security by selecting the relationship and checking the Apply security filter in both directions checkbox.
This option is only relevant if you have set row-level security in your model.
For a RLS to be effective across multiple instances of Dim table and not explicitly on the one which we created ,we have to explicitly Apply security filter in both directions.
For example, I have 2 DIM tables for Employee and Company, and 2 fact tables for EmployeeSalary and Sales.
Company and sales are 1:m relationship, Employee and EmployeeSalary are 1:1 relationship, Company and Employee are 1:m relationship
Assume that RLS is applied to the Employee table based on login.
If a bidirection filter is not applied, slicing by company is used for sales and employee salaries.
The result will be that the employee will be able to see not only his salary but also the sales of all companies
If a bidirection filter exists, then the user will only see sales for the company he is tagged in.
For more information，you can refer to：How does Row Level Security works when there is a BI-Directional Filter in Power BI/Tabular Model?
Hope it helps,
Community Support Team _ Caitlyn
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
