Showing results for 
Search instead for 
Did you mean: 
PatrickCote Frequent Visitor
Frequent Visitor

Report with Active directory User

Hi everybody,

I'm pretty new to Power BI and I have a question about AD reporting. I'd like to create some reports about AD users like:

  • Users created by month
  • Users with password never expire
  • Users enable/disable
  • etc.

For now, I can connect to AD, load the user table (is it the good one??) and after that.....i'm stuck!!

Can you please help?

Thank you

Phil_Seamark Super Contributor
Super Contributor

Re: Report with Active directory User

Hi, @PatrickCote


You are in the right place.  After that it's lots of exploring and expanding the various column headers to find what you need.


You can click the white part of a "record" cell to view a preview at the bottom of the page which I find helpful.


At the end of the exercise, you'll be more comfortable using the Query Editor.

To learn more about DAX visit :

Proud to be a Datanaut!

v-ljerr-msft Super Contributor
Super Contributor

Re: Report with Active directory User

Hi @PatrickCote,


You can connect to Active Directory from Power  BI Desktop following the instructions in this blog, load user table and computer table into Desktop.


In addition, here is similar thread about how get AD attributes in Power BI for your reference.Smiley Happy



sthomas2 Frequent Visitor
Frequent Visitor

Re: Report with Active directory User

I found Active Directory, but had concerns about seeing a field called "password". Is there any security issue with using Active Directory. I am assuming the password is encrypted or not visible.

brianandrews New Member
New Member

Re: Report with Active directory User

Hi! I Hope this is still an active thread. I'm trying to read Azure Active Directory through PowerBI (and PowerAPPS), but am not sure which user rights i need from my IT department. I want to read the rights per user on:

- the name of the mailbox

- the names of the mailboxes connected through groups

- the meta data per user and group




hope you can help. 

Helpful resources

Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 357 members 3,572 guests
Please welcome our newest community members: