Report on the roles defined in Tennant example Global administrator

[Singh_10]

Report on the roles defined in Tennant example Global administrator , number of users are global admin or member of any group

i am looking to create power bi report on this from tennant

[SaiTejaTalasila]

Hi @Singh_10 ,

You can create a power shell script with rest API commands to pull that data to a CSV file and you can store it on onedrive.You can pull the data from onedrive to power bi report.

Get Global Admins:

Get-AzureADDirectoryRole | Where-Object {$_.DisplayName -eq "Company Administrator"} | Get-AzureADDirectoryRoleMember

Get Group Members:

Get-AzureADGroupMember -ObjectId <Group Object ID>

I hope it will be helpful.

Thanks,

Sai Teja 

[v-xianjtan-msft]

Hi @Singh_10 

You can export the information you want in the Microsoft 365 admin center.

Under the “user” and “Teams and Groups” options, you can export the details of the members of the tenant.

If you only want to get information about a certain role such as Global Administrator, you can select that role in the filter.

^{Best Regards,}

^{Jarvis Tang}

^{If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}

[Singh_10 · Accepted solution]

Hi @v-xianjtan-msft 

Thank you for reply, actually i need to get this data directly to power BI is there any API i can use in Power BI to create report on it