Forum Discussion

tpoljak's avatar
tpoljak
New Member
9 years ago
Solved

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 ne...
Need Help
  • tpoljak's avatar
    tpoljak
    9 years ago

    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....

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

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's avatar
tpoljak
New Member
9 years ago

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's avatar
    AnselFeng
    Regular Visitor
    7 years ago

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