Power BI Desktop Link to Active Directory

[DougBate]

Very much a Noob when it comes to this but I'm looking for some assistance if anyone can help please?:

We report on Active Directory (historically using OldCmp.exe) which gives us just the right ammount of data we need.

Basically we need Power BI Desktop to query the Computer account, to provide

Computer Name,

O/S,

Service Pack level,

machine Type,

Computer account Password age

I can find all but the Computer account Password age withing the multitude of tables available to me in Active Directory.

Can anyone point me in the right direction please?

Thanks in advance

Doug

[v-caliao-msft · Accepted solution]

@DougBate,

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

In addition, here is similar thread about how get AD attributes in Power BI for your reference.

Regards,

Charlie Liao

[DebbieE]

this doesnt work for me straight away. 

You add in your Domain (Which I found in Azure Active Directory Primary Domain (the blog doesnt go into any detail on where to find your domain name) 

And I get Unable to connect

Details: "Active Directory: The active directory domain 'compname.onmicrosoft.com' couldn't be found."

However when I removed .onmicrosoft.com it still didnt work. the question is does this connector work. if it does, what am I doing wrong? If it doesnt, why is it in the connections list?

[Anonymous]

@v-caliao-msft i am using AD as source in power bi.  One of the column ObjectGUID is in the form of Binary.  i need to link that to another GUID column in database which is uniqueidentifier format.  How do i convert the Binary format to this uniqueidentifier?

[Anonymous]

@v-yuezhe-msft can u help