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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

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.
amitchandak
Super User
Super User

@Anonymous , there is new version update : https://docs.microsoft.com/en-us/microsoft-365/admin/usage-analytics/get-the-latest-version-of-usage-analytics?view=o365-worldwide

 

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

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here
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
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.