Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
tpoljak
New Member

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-Expire-Password https://msdn.microsoft.com/en-us/library/ms677837(v=vs.85).aspx ms-DS-User-Password-Not-Required https://msdn.microsoft.com/en-us/library/ms678643(v=vs.85).aspx ms-DS-User-Password-Expired https://msdn.microsoft.com/en-us/library/ms677838(v=vs.85).aspx ms-DS-User-Account-Disabled https://msdn.microsoft.com/en-us/library/ms677836(v=vs.85).aspx ms-DS-User-Account-Auto-Locked https://msdn.microsoft.com/en-us/library/ms678641(v=vs.85).aspx

 

Computer

status - Disabled or Enabled.

 

Can you please let me know how to identify these attributes?

thanks!

1 ACCEPTED SOLUTION
v-yuezhe-msft
Employee
Employee

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

6 REPLIES 6
Anonymous
Not applicable

I am new to Power BI so forgive me. I am trying to see enabled or disabled for computers and cannot see status under computer?  I am sure I am missing something easy.

Anonymous
Not applicable

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

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.

 

 

v-yuezhe-msft
Employee
Employee

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors