Integration Power BI with AD onpremise

[tpoljak]

Hi,

I've connected Power BI to the local AD environment and got really useful reports using a lot of Computer and User attributes. It's really useful!

To be prepared for all of my tests, I need to grab only additional three attibutes: Created, PasswordLastSet and Modified. I can grab it with PowerShell, but I don't know how to do it within Power BI.

Do you have an idea how to get theese three atributes by Power BI Desktop?

Thnx!

[v-qiuyu-msft]

Hi @tpoljak,

According to your description, it seems that you were connecting to the local AD use Active Directory data source, right?

Based on my research, I didn't find the official document list available attributes in this kind of data source. All tables are generated automatically in Power BI desktop. I would suggest you use the local AD administrator account to access this data source to see if you can find the required attributes.

Best Regards,
Qiuyun Yu

[tpoljak · Accepted solution]

Hi,

Based on my research, I can't also find these AD atributes in Power BI. I'm using this powershell script to get it:

Get-ADComputer -Filter {(name -like "*")} -properties * | Select Name, DnsHostName, Enabled, Created, PasswordLastSet.

Maybe will be useful to someone....

[AnselFeng]

@tpoljak are you connecting to local AD by synced it to Azure AD?