Can we store the data from the usage metrics report more than 30 days?

[cjiwani]

Hi All,
I am planing to make a custom report from the usage metrics data that Power BI generates. I was wondering can we get that data more than 30 days? or alternatively can we export that data and and store somewhere and stack updated data on top of it to have a historical data?

[V-yubandi-msft]

Hi @cjiwani ,

Has your issue been resolved, or do you require any further information? Your feedback is valuable to us. If the solution was effective, please mark it as 'Accepted Solution' to assist other community members experiencing the same issue.

[V-yubandi-msft]

Hi @cjiwani ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[V-yubandi-msft]

Hi @cjiwani ,

We noticed we haven't received a response from you yet, so we wanted to follow up and ensure the solution we provided addressed your issue. If you require any further assistance or have additional questions, please let us know.

Your feedback is valuable to us, and we look forward to hearing from you soon.

Thanks..

[V-yubandi-msft]

Hi @cjiwani ,

Thank you for reaching out to the Microsoft Fabric community. @ibarrau , Provided a valuable response. Along with his solution, I found a similar community thread that might also be helpful. Could you please take a look? Thank you for your response, @ibarrau .

Thread Link: Solved: Usage Metrics - how to get more than 30 days of da... - Microsoft Fabric Community

If my response solved your query, please mark it as the Accepted solution to help others find it easily.

And if my answer was helpful, I'd really appreciate a  Kudos .

[ibarrau · Accepted solution]

Hi. You can't get more than 30 days. The best way to build a metrics usage report would be getting data from activity event logs in the whole tenant. You can get 30 days the first time, store that and keep a script getting every day the new incomes so you can build historic data.

The request is for admins or Service Pricipals with permission to read-only Admin API. Link: https://learn.microsoft.com/en-us/rest/api/power-bi/admin/get-activity-events

I hope that helps

[cjiwani]

Hi @ibarrau, Thanks for the quick response. Do we get the same logs/ metrics like what we get in semantic model of usage metrics as I want to make a scalabe and detailed dashboard for long run.

Regards,
CJ 

[ibarrau]

You will get way more details with the API than usage metrics, but for keeping simple you can get the operations and filter by "View Report" to keep the events as the way you look at usage metrics.

Regards,

[Warren_Owen]

The method I use is to monitor the key metrics beyond 30 days is to connect the usage metrics report to the Scorecard/Goals capability. So I then monitor the running 30 day total of user/page views etc and have the Goals (preview) visual in my report to show the running total. 

[ibarrau]

Well. I actually depends on the requirement or the needs you have. If you just need to check some measures or goals, sure you can go that way. If it works and satisfy the need, it's perfect. I have answered with the most frequent solution that let's you grow an historic dataset with all the flexibility of the event logs happening in the whole tenant. So you are growing the views of report for all workspaces and will store all times. You will have maximum granularity and flexibility.

Regards,