Usage metrics for reports across all workspaces

[FabricLearnFabr]

Hi 

 I am looking for options to build a straight forward centralized report for usage metrics that provides a usage count of all reports and datasets of all workspaces by year and month.

I've tried using PreviewHub dataset from Admin Monitoring but data available there seems to be only for 1-2 Months.

What could be the best possible options for that?

[pborah · Accepted solution]

Hi @FabricLearnFabr , if you are the capacity admin, there's already a prebuilt app for this -

https://learn.microsoft.com/en-us/fabric/enterprise/metrics-app-install?tabs=1st

If you're not the capacity admin, whoever is can make this available to you. In any case pulling metrics across your entire tenant either requires you to be a capacity admin, or if you want write your own script to do this, you need to be a global admin.

[v-jtian-msft · Accepted solution]

Hello, pborah ,thanks for your concern about this issue.

Your answer is excellent!
And I would like to share some additional solutions below.

Hi,@FabricLearnFabr .I am glad to help you.

The maximum date retention period for usage metrics reports provided with power BI is 90 days, so if you want to get access to longer term report usage metrics data, you will need to access the data in other ways.

You can use PowerShell to export the audit log to a CSV file and use it as the data source for the Power BI report.
Or use Rest API to get the activity log
I hope the following related articles can help you:
URL:

Microsoft 365 Compliance audit log activities via O365 Management API - Part 1 | Microsoft Community...
Monitor usage metrics in workspaces (preview) - Power BI | Microsoft Learn
Access the Power BI activity log - Power BI | Microsoft Learn
The maximum period the API could access is 30 days.

2.You could try to customise a script (using PowerShell or a REST API) to periodically export activity log data and store it in a database. You will need to contact a programming-savvy member of your team to accomplish this.

3.Try to use other tools to help you achieve this effect.
URL:
How can you track activity history on Power BI beyond thirty days?

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[pborah · Accepted solution]

Hi @FabricLearnFabr , if you are the capacity admin, there's already a prebuilt app for this -

https://learn.microsoft.com/en-us/fabric/enterprise/metrics-app-install?tabs=1st

If you're not the capacity admin, whoever is can make this available to you. In any case pulling metrics across your entire tenant either requires you to be a capacity admin, or if you want write your own script to do this, you need to be a global admin.