Getting total of users and migrated users in a domain within AD

[Daemetius]

Hello,

So I am trying to get the data of the total of users in our company's Active Directory. I used the AD connector, but there are a bunch of domains and tables where some are empty and others aren't. Is there a generic column or table that presents information on the amount of of users in a company's AD? We are migrating users to O365 and I wanted to see if I could get the total of employees and along that those that are migrated for a progress dhasboard.

Any help is appreciated! 

Thank you! 

[v-yuezhe-msft · Accepted solution]

@Daemetius,

Connecting to Office 365 Adoption Content Pack Power BI Template in Power BI Desktop, you should be able to get total amount of the users in O365. 

After that, in the PBIX file, you can connect to Active Directory, enter your domain name, there is a user table in the list, you can get total users of your domain after importing data from the table.


Reference:
Customize the Office 365 Adoption content pack
POWER BI AND ACTIVE DIRECTORY FOR SYSTEM ADMINISTRATORS



Regards,
Lydia