RLS Issue

[MathiasChd]

Hello everybody:

I need help to implement RLS in my organization, I have the following table of facts

Date	Brand	Tipe	Cartera	Sales
25/5/2021	Mayorista	Campo	Vendedor1	15
25/5/2021	Minorista	Pymes	Vendedor5	41
25/5/2021	Revendedor	Local	Vendedor7	20
25/5/2021	Mayorista	Ciudad	Vendedor2	23
25/5/2021	Mayorista	Empresa	Vendedor2	27
25/5/2021	Minorista	Retail	Vendedor5	91
25/5/2021	Revendedor	Local	Vendedor8	30
25/5/2021	Mayorista	Campo	Vendedor4	11
25/5/2021	Mayorista	Ciudad	Vendedor3	96
25/5/2021	Minorista	Agencia	Vendedor6	32
25/5/2021	Revendedor	Internacional	Vendedor8	22
25/5/2021	Mayorista	Campo	Vendedor2	92
25/5/2021	Minorista	Agencia	Vendedor7	87
25/5/2021	Revendedor	Local	Vendedor7	52
25/5/2021	Revendedor	Internacional	Vendedor8	36
25/5/2021	Mayorista	Ciudad	Vendedor3	49
25/5/2021	Mayorista	Campo	Vendedor1	45
25/5/2021	Minorista	Pymes	Vendedor5	42
25/5/2021	Revendedor	Local	Vendedor7	41
25/5/2021	Mayorista	Ciudad	Vendedor2	49
25/5/2021	Mayorista	Empresa	Vendedor2	62
25/5/2021	Minorista	Retail	Vendedor5	23
25/5/2021	Revendedor	Local	Vendedor8	51
25/5/2021	Mayorista	Campo	Vendedor4	31
25/5/2021	Mayorista	Ciudad	Vendedor3	28
25/5/2021	Minorista	Agencia	Vendedor6	51
25/5/2021	Revendedor	Internacional	Vendedor8	55
25/5/2021	Mayorista	Campo	Vendedor2	14
25/5/2021	Minorista	Agencia	Vendedor7	59
25/5/2021	Revendedor	Local	Vendedor7	26
25/5/2021	Revendedor	Internacional	Vendedor8	51
25/5/2021	Mayorista	Ciudad	Vendedor3	93

And I need to implement the RLS under the following conditions

USER	RLS	Email
CEO	Total	CEO@company.com
CFO	Total	CFO@company.com
Manager Mayorista	Mayorista	Manager Mayorista@company.com
Manager Minorista	Minorista	Manager Minorista@company.com
Manager Revendedor	Revendedor	Manager Revendedor@company.com
Vendedor1	Vendedor1	Vendedor1@company.com
Vendedor5	Vendedor5	Vendedor5@company.com
Vendedor7	Vendedor7	Vendedor7@company.com
Vendedor2	Vendedor2	Vendedor2@company.com
Vendedor8	Vendedor8	Vendedor8@company.com
Vendedor4	Vendedor4	Vendedor4@company.com
Vendedor3	Vendedor3	Vendedor3@company.com
Vendedor6	Vendedor6	Vendedor6@company.com

I saw the Radacad materials but couldn't do it with them.

Could you help me?

Thanks!

[MathiasChd]

Thanks for help me. I have other problem with RLS. I´m going to publish it in another post

[v-kelly-msft · Accepted solution]

Hi  @MathiasChd ,

Create the following 11 rules for different users,as CEO and CFO,they could see all the data,you dont need to set the rules for them:

And you will see:

Pls check my .pbix file for details.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!