cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

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

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! 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

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

@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.
1.JPG

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



Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Highlighted
Microsoft
Microsoft

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

@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.
1.JPG

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



Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (891)