Monitoring usage of hundreds of reports

[Anonymous]

I am working on a tenancy that supports nearly a thousand reports. These reports need regular maintenance to cope with the changes that often occur in our dynamic environment. This can be a time consuming activity, and I would like to rank the reports so that the most important reports get done first.

I know I can get the usage of a specific report, and I can also use a Powershell Cmdlet to get usage across the whole tenancy for a given day. Is there a way of getting the usage of all the reports so I can rank them in terms of importance? (Importance is a known function of the frequency of access and the job title of the person using the report.)

[lbendlin]

Take your tenant audit logs, stuff them into dataflows, and consume these dataflows in a Power BI report (ideally one that is NOT on the tenant in order to not skew the results).  There are capacity metrics templates, but it is also easy to roll your own where you take a side feed from your job titles to calculate the importance)

CAVEAT:  tenant audit logs only go down to report level, not page level.