I have used the Microsoft Visio Organization Chart Wizard many, many times over the years, but I usually use it from text files, and I had been aware that I was not getting good results from the Microsoft Exchange Server directory option, now that I use Office 365. I was always getting just the first Personnel record (Admin). Well, I was prompted to find out why, and was amazed to find the answer by Winnie Liang in Creating Organizational Chart from AD Information.
In short, the answer is to create a new desktop Outlook profile without any cached data, and with just an Office365 account.
Then, just open that profile and Visio to run the wizard…

Now everything works! Thank you Winnie!
Shame that there is no mention here….
This was a great help to me. The only bad thing is that it no longer seems to support importing the images from Exchange into Visio anymore. Have you run into this issue David or found a resolution to this?
I haven’t had to use the Org Chart for a while, but it seems to me that Microsoft have problems synchronizing the various places where photos are stored … Information about profile picture synchronization in Microsoft 365