Reports from Microsoft Graph API only available after 2 days

Question

We are using Microsoft 365 usage reports endpoints to fetch daily reports i.e. we pass {date_value} to fetch report on a particular date. We want to call these endpoints to query reports for yesterday, but when we query them, we get a blank report, if we wait for one day and query it at evening on the next day, we get the data in the report. This means the report is not available to be fetched until two days are passed. Is this expected behavior or something needs to be done to remediate this ? Please let us know at what time a report for a day is available to be queried.

Answer 1

Hi @Faisal -Cloud9 ,

As mentioned in both M365 admin center's reports section and this documenation, data won't exist for all reporting periods right away. The reports become available within 48 hours. The same is applicable to M365 Usage Reports Graph API/endpoints response based my testing in Postman or Graph explorer. "Last Updated Date" in M365 Admin Center Usage Reports section is same as "Report Refreshed Date" in M365 Usage Reports Graph API response.

As you can see in below two example screenshots which were taken at 28th December 2021 7:45 & 7;47 PM UTC, , Last Updated Report Dates were 26 December 2021 UTC and 27 December 2021 UTC respectively in M365 Admin Center Usage Reports section.

Hope this helps.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have further questions about this answer, please click "Comment".