Forum Discussion
M365 User export CSV format changed
- Dec 18, 2024
You can always get the same info via PowerShell, and format it per your preference. And there are plenty ready-to-use script samples available online, if you don't feel like creating your own. Here's one of Tony's: https://practical365.com/create-licensing-report-microsoft365-tenant/
I opened a case with Microsoft. The engineer was aware of the change, but had no documentation about it, so we closed the case. I also recently noticed that they changed the columns in the export again. I had to rework one of my automated processes again because of this. However, one good point is that the Licenses field now contains a "+" delimiter like it did in the old report. The only thing I think is an outstanding bug is in the UserStatus field. It shows guests as "Guest", but it shows "Unlicensed" for unlicensed members and a list of non-delimited licenses for licensed members. I feel it should just show "Member" for member accounts. I can work around this issue, so it's not a problem for me.
- Andrew_WooJan 12, 2025Iron Contributor
Yes, I have reworked all Power Automate, Power BI and Power Query.
Just pray hard and no more changes again.