How to find Logged in users AD Group in DAX

[nssidhu]

In DAX Expression i want to find out if logged in user is a memeber of Specific Group. 

How can i find that ?

[v-shex-msft]

HI @nssidhu ,

Please share more detail information to help us clarify your data structure and coding formula. Is there any table fields stored log status and group info?

Regards,
Xiaoxin Sheng

[nssidhu]

The question is about comparing the Loggedin user(USERPRINCIPALNAME() ) to check if belongs to a specific Role in a Power BI Service.
Member are added to Role in Power BI Service. There is no table.

Psudo Code
Power BI Service Role "SuperAdmin" with the following Members

        user1@company.com
        user2@company.com

I want to Check if USERPRINCIPALNAME() is equal to one of the member in "SuperAdmin" Role in DAX Formula.

[v-shex-msft]

Hi @nssidhu ,

Maybe you can try to set up username mapping table with rls based on username/userprincipalname function:

RLS with UserName()

Regards,

Xiaoxin Sheng

[nssidhu]

There is not table.