07-27-2015 04:14 AM
I'm trying to query active directory to retrieve a number of custom attributes added to AD that I can view in ldp.exe but I'm having trouble locating them when I use the Active Directory Power BI connector.
The list of users in stored in a particular OU but how do OU's and Base DN's relate to the way Power BI queries AD?
07-27-2015 06:16 AM - edited 07-27-2015 06:26 AM
Yes, The latest version of Desktop downloaded today. The ldp.exe tool is a MS tool from Windows 2003 https://technet.microsoft.com/en-us/library/cc772839(v=ws.10).aspx but still works or you could use adsiedit.msc but you end up with a folder tree of OU's which you can expand to find the 1 you want and list the properties
07-27-2015 06:31 AM
Have you try query in distinguishedName of AD with required OU unit kike this,
Please see only Blue squire query to get required OU's.
I have try playing with this columns.
Hope this helps
BI Solution Architect
MCSC, MCTP, CSM
BI Blog-Business Intelligence Mentalist
SQL Blog-SQL Server Mentalist
Founder & Leader of Global Power BI User Group
firstname.lastname@example.org | www.aptude.com
07-27-2015 06:55 AM - edited 07-27-2015 07:04 AM
That would get me to the OU but similarly to your image I don't get all the attributes (columns) for the users. In your image you have 17 columns, I get 18 but using ldp.exe I can view over 50 attributes / columns / dimensions for each CN for example in my PowerBI data I can't see the attribute givenName or company
In the user view there are a number of columns with "Record" and if I right click I can drill down or create a new query from. If I choose msExchCustomAtrributes and click record I can see the attributes I need to query for but thats just 1 record i.e 1 specifc user not all the users who share the OU I filtered for earlier
07-27-2015 07:43 AM - edited 07-27-2015 07:44 AM
Forgive my newness to PowerBI. I was able to expand the column msExchCustomAttributes to select the additional attributes it contained. I was used to the icon beside the column name being just to filter values like in excel.
Thanks to all for the help