Devices aren't listed when importing data from AD

[Francias]

Hello, I am importing Active Directory to PowerBI to create a dashboard for devices. All devices are located in dedicated OU, but when I import tables from AD I don't see any devices anywhere. Is there a way to get them listed there?

[v-achippa · Accepted solution]

Hi @Francias,

Thank you for reaching out to Microsoft Fabric Community.

When you import the data from AD, the Power Query engine detects related columns that are not part of the original table but they might have stored in a related table(these columns can be referred as Complex Columns). These columns can be appear when you click on Expand Icon next, indicating that they contain data that can be expanded from a related table. To access more information you need to expand the complex columns in Power Query. In your case, Devices you can click on expand icon next to the related table of Devices, so that you can able to pull the required columns. 

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thanks and regards,

Anjan Kumar Chippa