How to show logged in user owned records and group records in power bi dashboard within D365

[Anonymous]

I am trying to show logged in user owned records in power bi dashboard within D365 Customer Engagement and achieved using RLS.

Also I need to show logged in user's Group related data in Power BI dashboard but I am unable get logged in user info to retrieve group data.

Please suggest how to achieve this one.

Thanks,

Praveen

[v-shex-msft · Accepted solution]

HI @Anonymous,

According to your description, It seems like you want to trace the usage of current power bi contents. If that is the case, I think you may need to get data from 'audit logs' and do analysis with these records.

Track user activities in Power BI - Power BI | Microsoft Docs

For dynamic RLS based on the current user, you can configure a 'user mapping' table to map username with current user account then use the relationship to link and filter to these related records.

Solved: RLS with UserName() - Microsoft Power BI Community

Regards,

Xiaoxin Sheng