inheritance permission from dynamics 365 "CRM"

[srjohny]

Hello everyone, I've created a report for my salespeople, As I'm administrator I can see all sales but for our salesperson, they should only see the own sales , we have permission on Crm SIde, how can we make powerbi respect  those permissions? is it possible inherit those permission from CRM? 

[Anonymous · Accepted solution]

You want to set up Dynamic Row Level Security.

There is a good guide for it here:

https://radacad.com/dynamic-row-level-security-with-power-bi-made-simple