question

WenhuiZhang-7991 avatar image
0 Votes"
WenhuiZhang-7991 asked WenhuiZhang-7991 commented

Microsoft Graph API Report Period option is not working

Does anyone have trouble in fetching M365 email/SharePoint/OneDrive activity report data via Graph API?
Both query (query by Date and Period) were working fine few hours ago (before 1AM 2021-08-31 US time zone). But now, only the query URL with Date is working. The other one with Period (D7, D30, D90, D180), returns empty result.
I tried on MS Graph Explorer and Power Automate, and I also tried on different tenants, problem persists (I am the global admin).

Any idea? Thanks in advanced.

microsoft-graph-reports
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

We are looking into this. Please attach the request id and timestamp of two requests for which the date has data while the period that includes that date has no data.

0 Votes 0 ·
JrmieMartin-6802 avatar image
1 Vote"
JrmieMartin-6802 answered

Hello,

@Danstan
I have also the same problem on differents tenants even if I have data on https://admin.microsoft.com/AdminPortal/Home#/reportsUsage

Any update on this ?

Thank you

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Danstan-MSFT avatar image
1 Vote"
Danstan-MSFT answered WenhuiZhang-7991 commented

@JrmieMartin-6802 @WenhuiZhang-7991 This should be now working as expected. Please try again. Here is a screenshot from my test with period='D30'
128544-reports-fixed.png



reports-fixed.png (53.9 KiB)
· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thank you for the feedback.
It is indeed working know.

1 Vote 1 ·

Please read my question carefully, I am talking about why the Graph API on Period option for Querying MS Report data returning empty response during 31/8/2021 to 1/9/2021 (Australian time zone).

0 Votes 0 ·

Please try again and let us know.

0 Votes 0 ·

I am asking why it happens during that timeframe. But you are just lazy to answer and telling me to try again. I am not asking whether it's fixed. Please do not make lazy answer to gain Q&A 'likes' or good feedback.

0 Votes 0 ·
WenhuiZhang-7991 avatar image
0 Votes"
WenhuiZhang-7991 answered WenhuiZhang-7991 commented

I just tried (9AM 6th Sep 2021 Australian Time zone) on Graph API v1.0, it's not working:
129424-image.png




I have tried on our end and all our tenants, none of them working with version 1.0. This version has never worked since the beginning of August. Moreover, my original question is not about Graph API v1.0, because this version never worked, I was using Beta version, it works pretty smooth, but as I mentioned on my question ,even the Beta version was behaving abnormally. The response code was 200, which is fine, but returns nothing during 31st August to 1st Sep 2021 (Australian time zone), it comes back after 2nd Sep, what was going on and why your API v1.0 is working?


image.png (32.1 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

This is an issue with Graph Explorer trying to parse the csv to json. Try on postman

0 Votes 0 ·

It also happens to Microsoft Custom connector in Power Automate, why?

0 Votes 0 ·