03-10-2017 09:00 AM
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
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?
03-11-2017 06:47 PM
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!
03-12-2017 11:28 PM
04-25-2018 05:47 AM
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.
10-18-2018 05:05 AM
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.