Get data with Active Directory - some existing groups are not found

[Sica]

Hello,

I am trying to retrieve data via Active Directory. I would like to know which users have access via a specfic Group.

The code works, but not all groups from Azure Active Directory are listed.

Do you have any idea how I can retrieve all existing groups of an Azure Active Directory using PBI.

[lbendlin · Accepted solution]

The best way to do this is not to do it in Power BI.  Use Powershell to enumerate groups and memberships. Be aware that groups can contain other groups so your code must handle this recursively.