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
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

tpoljak's avatar
tpoljak
New Member
9 years ago

Hi Lydia,

 

Thank you for your advice. Based on your instruction I found "useraccountcontrol" attribute and with description I can use it to get all status. Thanks!

 

Regards

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi tpoljak,

    As the issue is resolved, could you please accept helpful reply as solution? That way, other commnity members who have similar issues would benefit from this solution.

    Thanks,
    Lydia Zhang