Security Model implementation in Power BI as same as Dynamic365

Question

Hi Experts. Hope every one doing good.I am new to Power BI. I have a requiremet on Power BI reports, Please guide me to implement it.Connector details:Connector : Dataverse (Dynamic 365 CRM)Connectivity mode : ImportTarget Table/entity : Incident/CaseRequirement : Need to implement Dynamic 365 security model in Power BI Reports. Below are the senarios.1. When user A logs in, user A must see his/her owned records only.2. When user A logs in, user A must see his/her owned records, team member records and reords shared to that team. (User A is like Team lead)&nbsp;&nbsp;&nbsp; EX :&nbsp;&nbsp;&nbsp; Sales Team has user A, user B, user C..&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; When user A logs in, he should see user A,B,C records and also records shared to the sales team.3. When user A logs in, user A must see his/her Business unit records.&nbsp;&nbsp;&nbsp; EX:&nbsp; India business unit has user A, user B, user C..&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; When user A logs in, he should see user A,B,C records and not other Business unit records.4. When user A logs in, user A must see his/her Business unit records and all child business unit records.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;EX:&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;India (user A)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; I&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;I&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; I&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;I&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Hyd (user B)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Ban (user C)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;I&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; I&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;I&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; I&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Hyd 1 (user D)&nbsp; &nbsp; &nbsp;Hyd 2 (user E)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;in above scenario&nbsp; User A should see, user A,B,C,D,E records.&nbsp;Please help me in this requirement.&nbsp;

parry2k · Accepted Answer

Anonymous&nbsp;you have to implement RLS (row-level security) in your model. check this post and use it in your model.
&nbsp;

✨ Follow us on LinkedIn 
&nbsp;
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤&nbsp;Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation! 
&nbsp;
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

Forum Discussion

Security Model implementation in Power BI as same as Dynamic365

2 Replies

Related content

Implementing Region-Level Security

One Lake Security implementation doubts

RLS,CLS Security Design and Implementation

Implement Dynamic RLS with Azure Security Group

MDM implementation