Forum Discussion
Getting actual usernames from Active Directory
Hi, I was asked to fetch a list of all our usernames from Active Directory by using PBI. The problem is that it loads only displayName and distinguishedName at actual querry editor.
Figured this out by myself like 5 minutes after the post (typical).
The trick is that you can actually choose what you want to see from the record
Hi, I didn't really do anything else but chose AD as a data source and typed in our domain name.
Hi Anonymous, thanks for the reply. I figured you might say that. Just weird because the Desktop app is telling me the "onmicrosoft.com" default domain listed as the "default" domain on O365 Admin and as the "primary" domain on AAD couldn't be found. Have submitted a support request to Microsoft and will see what comes back.
Have attached the two places where I'm seeing this domain in case you spot an obviously mistake.
Thanks again.
Ben