Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Microsoft 365 usage analytics daily data

Hello team, I have a problem because in the Microsoft 365 usage analytics app I only see data aggregated by month in table "TenantProductActivity" and and data only of 1/5/2020 in the table UserActivity.

 

Also when I connect to this using PowerBI Desktop i see in the table "UserActivity" in the TimeFrame column only values of 1/5/2020, but in the "Microsoft 365 admin center" I see data daily. 

 

Does anyone why in the "UserActivity" table is only one day? its related to limitations or I'm doing something wrong?

 

Thanks

5 REPLIES 5
lukaszcracow
Frequent Visitor

Hi guys,

 

I've encountered the same problem. My job is to monitor and report MS Teams usage in organisation. I am granted the Report Reader role and am able to access Microsoft 365 usage analytics data model. However the data in the model is aggregated into months (as it is described above) ("This API provides information about the monthly trend of usage of the various Microsoft 365 services."). 

Is there any chance I can access the same data but on higher level of granularity, i.e. aggregated into weeks/daily?

 

I'd be really grateful for any suggestions. 

Anonymous
Not applicable

Hello, the issue is not about refresh. There are two questions:

1- Why i see only data of May-2020

2- Why the data in table UserActivity is monthly aggregated and not daily. 

v-diye-msft
Community Support
Community Support

Hi @Anonymous 

 

Hope this helps:

Please refer to this document:

How often is the data refreshed?

When you connect to the template app for the first time, it will automatically populate with your data for the previous 12 months. After that, the template app data will refresh weekly. Customers can choose to modify the refresh schedule if their use of this data demands a different update rhythm.

The back-end Microsoft 365 service will refresh data on a daily basis and provides data that is between 5-8 days latent from the current date.

https://docs.microsoft.com/en-us/microsoft-365/admin/usage-analytics/usage-analytics?view=o365-world...

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.
Anonymous
Not applicable

Hello Amitchandak, I have the version 8 installed. I think is the last one, right? If not, the latest one have the informacion daily and not aggregated monthly? 

Regards

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.