cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PatrickCote
New Member

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

5 REPLIES 5
Vikram001
Regular Visitor

I have created AD Report in Power 

v-ljerr-msft
Microsoft
Microsoft

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

 

Regards

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

 

WITHOUT ACTUALLY GETTING ACCESS TO THEIR MAILBOXES.

 

hope you can help. 

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.

Phil_Seamark
Microsoft
Microsoft

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 : aka.ms/practicalDAX

Proud to be a Datanaut!

Helpful resources

Announcements
June 2022 update 768X460.jpg

Check it out!

Click here to read more about the June 2022 updates!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors