Forum Discussion
Integration Power BI with AD onpremise
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!
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....
3 Replies
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 YuHi,
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....
