How to allow end user to see report based on their LDAP id in PowerBI ?

[Anonymous]

Dear All,

I have prepared one local report in PowerBI, and i am seeking to publish these reports only to selected few users here. However i want them to see report in PowerBI based on their LDAP Id only (Security).  LDAP id is mentioned in my backend table (Dataset).

Need suport here.

Thanks & Regards,

Chander

[Anonymous]

Thanks Ibendlin, let me put some brain on this...

Best Rgds,

[lbendlin · Accepted solution]

Read about implementing Dynamic Row Level Security.  You may need to trade your LDAP IDs for email addresses and USERPRINCIPALNAME() but the idea is the same.