Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 | |
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!
Solved! Go to 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!
Thanks for help me. I have other problem with RLS. I´m going to publish it in another post
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!
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |