topic Re: Function to Get Profile - RLS in DAX Commands and Tips

Function to Get Profile - RLS

sangi1981 — Tue, 18 Apr 2023 07:05:54 GMT

Hi all,

is there a function, like userprincipalname(), to get role/profile of user, to implement RLS a role level and not user level?

Thank you in advance,

Sandro

OwenAuger — Wed, 19 Apr 2023 10:05:23 GMT

There is no DAX function that gives any further information about the current user.

I would suggest using the Active Directory connector to import a table containing additional user attributes, and use that to help define RLS rules.