Complicated roles

[Melissa]

Hi @Harris,

Have you examined Row Level Security?

https://forum.enterprisedna.co/t/scale-your-power-bi-reporting-with-row-level-security/469

https://forum.enterprisedna.co/t/row-level-security/4415

Also check the search option for more related content, like:

Multi Criteria or Tables for RLS

Hi Melissa, Thanks. It already solve 90% of the problem. I apply you recommendation in my model and it can limit the data access for each user . Actual, there is no relationship between region and sales person and they came from 2 different data sources, but i may create a table for all combination of region and sales person. But how can I keep to use DIM-Customer as filter table (slicers in report) as it get more customer information that exclude in User control table? As I cannot build a…