Getting Usergroup in the Active Directory

[andrehawari]

Hi, 

I am using power bi service that connected to azure analysis services using live connection.

I need a function that similar like function : username(), but to retreive the user group that the username belongs to.

For ex: use username() function I can get string like : john@contoso.com

John@contoso.com is under AD group managergroup@contoso.com --> this one is the value I want

Any suggestion how to do that in dax ?

Thanks

[v-juanli-msft]

Hi @andrehawari

By tests, I'm afraid that we may not use DAX expressions to get Azure AD group currently in Power BI.

You can do this in PowerShell pretty easily.

Get AD group

Gets the members of an Active Directory group

Best Regards

Maggie