cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
v_mark
Helper III
Helper III

Usage Metrics Report in Power BI

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

1 ACCEPTED SOLUTION
lbendlin
Super User III
Super User III

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.

View solution in original post

1 REPLY 1
lbendlin
Super User III
Super User III

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.

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors