Usage Metrics Report in Power BI

[v_mark]

Good day,

One of my projects is to create a Usage metric report in Power BI. We are talking about around 60 workspaces.
The idea is to have a more comprehensive report versus on pre-built usage metrics in power bi. and publish just like a normal report in Power BI Service..

Luckily  I was able to see some resources online. 
(2) Automate Power BI Usage data across workspaces using Paginated Reports | LinkedIn

Build Your Own Power BI Audit Log; Usage Metrics Across the Entire Tenant - RADACAD

Probably tied up into an employee table so we can see the heirachy per program/dept about their usage of the report in each workspace. Do I need to have admin/tenant access to do that? What else do I need to consider when making such a report, 
Anyone who was able to do it before. Would be great and possibly resources on the web to start with..  

Thank you so much

[lbendlin · Accepted solution]

You need two things

1. Somebody needs to have initiated Usage Metrics for the report(s)

2. you need to be a member of the workspace(s) holding the usage metrics dataset(s)

3. you need to keep in mind that usage metrics datasets and their reports will disappear if nobody looks at these reports for  a certain period of time.  Means you need a process to keep these alive.

Then all that's left is to modify the report template so it connects to multiple datasets.

For a larger organization this process becomes very ugly very quickly.  What we do instead is offer report usage information based on the tenant audit logs.  It doesn't have page level usage details, but it keeps history for much longer and doesn't require any keep-alive acrobatics.