The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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
Hi @sangi1981
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.
User | Count |
---|---|
14 | |
12 | |
8 | |
6 | |
5 |
User | Count |
---|---|
28 | |
19 | |
13 | |
7 | |
5 |