Access Active Directory Object Properties

[AvcRomeo]

I am tyring to get to AD object propertiese and am wondering if there is "Table Map" of some sort that I can reference to find where \ how I can get to certain propertiese ?

I.e. I figured out I needed to Expand the user column to get to home Drive, mail and principal name information

I am not currently finding the right table\columns with information that identifies "contact" vs. "user" objects ?

Or identifies disabled vs. enabled objects ?

I have been going through the "Computer" "User" & "Contact" tables and so far have not seen this information.

I can get this information easily through PowerShell but getting into the PowerBI Desktop tool is my current need.

I am new to PowerBI so please excuse what might be a very simple question.

thanks

[AvcRomeo]

I think I am on the right track in trying to look for Attributes in the AD Schema.

https://msdn.microsoft.com/en-us/library/ms675090(v=vs.85).aspx

I.e. ms-DS-User-Account-Disabled attribute

https://msdn.microsoft.com/en-us/library/ms677836(v=vs.85).aspx 

But I am so far unable to find this under the "User" or "Contact" table 😞

Any help would be appriciated.

[v-qiuyu-msft]

Hi @AvcRomeo,

As we know, the Power BI Desktop is used for retrieving data from the Active Directory data source. The tables available in desktop is generated automatically when we connect to Active Directory, which are determined by the Active Directory settings. I would suggest you contact the system administrator to check which table stores required information. And try to use system administrator account to retrieve Active Directory data.

Best Regards,
Qiuyun Yu

[AvcRomeo]

Hi @v-qiuyu-msft,

Thanks for responding.

Do you have any suggestion for what tables sources to look for ?

I am using an admin account to retreive data.

The following is an example of the data I am seeing.