We have a PowerShell script that executes on a scheduler job daily to extract the Power BI audit log records and writes them to a file on a shared folder where they are picked up for processing. Note, sometimes it takes more than 24 hours before the audit data is available so we had to code around this to allow for a flexible lag.
We then wrote a custom Power BI report that joins the account information pulled from these audit logs to internal data sources so we can show data at multiple levels to track usage and adoption - by department, by title, etc.
@sirui_sun The Report Usage Metrics Report fails to load within our organisation. Especially the ViewsCount part of it just tries to load for 10 minutes, and then gives up with an 'out of resources' error message.
Is there a way or an existing idea post out there (before I create it) to have an option to merge Dashboard and Report Usage Metrics? Soemtimes we look at the dashboard vs report and if they are much the same except for dirll down options. Combining the usage numbers often would be helpful (but sitll breaking them out for other needs).