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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
MEFOX
Helper III
Helper III

Report Usage Metrics older than 90 days

It looks like the usage metrics only go back 90 days. Is there a way to go back 6 months?  

5 REPLIES 5
v-yalanwu-msft
Community Support
Community Support

Hi,, @MEFOX 

Is your problem solved? If so, Would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft
Community Support
Community Support

Hi, @MEFOX ;

The automatic usage metrics reports takes the last 90 days only. The new usage metrics is taking last 30 days only. If you want to build an historic dataset about it, you should consider taking the audit logs from office 365 or the activity logs from Power Bi Rest API and store the data in someplace you will hadle later with Power Bi.

https://community.powerbi.com/t5/Service/Usage-metrics-quot-90-lt-quot-days-issue/td-p/1191455


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

MEFOX
Helper III
Helper III

Does this mean that going forward I will only have 30 days of usage metrics or will PowerBI.com continue to provide 90 days?

What is the version of your workspace?

Classic workspace supports 90 days while the modern workspaces support 30 days metrics.

You can have more understandign from here:

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-usage-metrics

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-modern-usage-metrics

 

I use modern workspace and just need last 30 days data so it works for me but if more is needed I rely on API based solution.

 

nitishsh91
Solution Supplier
Solution Supplier

Hi @MEFOX 

 

By default automatic usage metrics go back only 90 days. The new usage metrics is actually taking last 30 days.

If you want to build an historic dataset about it, you should consider taking the audit logs from office 365 or the activity logs from Power BI Rest API and store the data in someplace you will handle later with Power BI like in csv\excel file or something.

You can aslo look at below url to get an understanding:

https://radacad.com/build-your-own-power-bi-audit-log-usage-metrics-across-the-entire-tenant

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors