Forum Discussion
Active Directory
I am looking for a report where I can see active users, inactive disabled users etc
Hi Balkrishnan ,
You can connect to Active Directory from Power BI Desktop following the instructions in this blog, load user table into Desktop.
As per this similar blog and similar thread, user account status are controlled by the userAccountControl attribute, you may expand userAccountControl column from user table in Power BI Desktop, then check the values.
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
Hi Balkrishnan ,
You can connect to Active Directory from Power BI Desktop following the instructions in this blog, load user table into Desktop.
As per this similar blog and similar thread, user account status are controlled by the userAccountControl attribute, you may expand userAccountControl column from user table in Power BI Desktop, then check the values.
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
please help me to get
a. Number of disabled users
b. Number of enabled but stale users
c. Number of enabled but locked-out users
d. Number of looped nested groups
e. Number of users with passwords that never expire
f. Number of users with removal recommendationsI connected, but get null values for some disabled userAccountControl. When I look at the attribute in AD it's 514. Why does it show null in PowerBI. This is happening for a majority of disabled users.
