Forum Discussion

Copper Contributor

Sep 02, 2021

Solved

Microsoft 365 usage data from Graph API broken?

Hi Everyone, I've been using data from the Graph API for Mailbox and OneDrive usage statistics for a while, but for the last few days it seems that it broken. If I run the following in the Gr...

microsoft 365

VasilMichev
Sep 07, 2021
That's expected: https://techcommunity.microsoft.com/t5/microsoft-365-blog/privacy-changes-to-microsoft-365-usage-analytics/ba-p/2694137

VasilMichev

MVP

Sep 03, 2021

Graph explorer doesn't render CSV files, which is the default response you will receive from calling the above. Use Postman or any other tool, or just request the JSON instead

For example:
GET https://graph.microsoft.com/beta/reports/getEmailAppUsageUserDetail(period='D7')?$format=application/json

Hugh_Burns

Copper Contributor

Sep 06, 2021

Thanks VasilMichev

Turns out the CSV data is being returned, but is in the wrong format. The UPN and Display Names are showing as some sort of GUID or ID, instead of actually showing the correct data. This is why my integration broke. Anyone seen this or know why its happening? Pic attached.

VasilMichev
MVP
Sep 07, 2021
That's expected: https://techcommunity.microsoft.com/t5/microsoft-365-blog/privacy-changes-to-microsoft-365-usage-analytics/ba-p/2694137
- Hugh_Burns
  Copper Contributor
  Sep 07, 2021
  Aha, thanks VasilMichev