Forum Discussion

tpoljak's avatar
tpoljak
New Member
9 years ago
Solved

AD attributes in Power BI report

Hi,   I'm looking to find these AD related attibutes within Power BI desktop: User ms-DS-User-Account-Disabled https://msdn.microsoft.com/en-us/library/ms677836(v=vs.85).aspx ms-DS-User-Dont-Expi...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi tpoljak,

    Based on your description, you want to query properties of Active Directory objects(users and computers)  from Power BI Desktop.

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

    As per this similar blog and similar thread, user account status and computer status are controlled by the userAccountControl attribute, you should be able to expand userAccountControl column from user table and computer table in Power BI Desktop, then check the values.

    Thanks,
    Lydia Zhang

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I'm having the same problem.  I built the logic to query AD's USER account status, then extract the binary into enabled/disabled status.  However I can't find the same field for Computer Accounts in AD.  

 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

It is the user column still.  The naming through me for a loop and I kept looking for a device or workstation column with the info.