Report usage metrics

[svenchio]

Dear community members, I would like to "pick your brain" on the topic of "Power BI reports usage", the scenario is as follow, we just receive a mandate to understand and document how reports are usedacross our the tenant, I would know how to query all our workspaces and look for all reports in each, from here, the next step would be to get some metrics con the report, metrics like when was the last time this report has been accessed (e.g. remove never used reports, pun in quarentine those that seemed abandoned), and other metrics like views per day, unique viewers, and views per user, etc.; I think is clear that, this cannot be done manually nor a one time only but something I can extract perhaps frequently and save the results to start building tendencies and historical analysis. 

I know FUAM is great in general monitoring of fabric ecosystems, but, how good is to get reports metrics? I just want to ask this body of knoledge for best practices and expert advise to get started. Thanks in advance for your advise. 

[fcerullo]

Do Views of a pinned visual count as Views in the Usage Metrics for the source Report?

[tayloramy · Accepted solution]

Hi @svenchio, 

The way that I do this is using the GetActivityEvents API endpoint.  Admin - Get Activity Events - REST API (Power BI Power BI REST APIs) | Microsoft Learn

I pull data from this daily and store it in a lakehouse. The API only maintains 30 days of data, so storing it allows me to capture more trends. 

This data will tell you about almost every action taken in Fabric, including who is viewing reports and when. 

Once you have the data, it is quite simple to build some reporting on it to identify highly used and unused reports. 

[svenchio]

Hi @tayloramy  a bit on the same topic (monitoring) have any experience on monitoring via Office 365 Unified Audit Log by any change?  I have a combination of embedded reports and non-embedded reports  and it was suggesges that Office 365 Unified Audit Log would be a complementary montiring solution for embedded reports, if you have any practice experience you can share on this, it would be very appreciated. 

Thanks and all lthe very best. 

[tayloramy]

Hi @svenchio, 

I do not have experience with the Office 365 Unified Audit Log, I tend to stick to my lane in Fabric 😛 

I do know that last year when I was looking at unified purview audit logs, the info displayed there was the same as what was available from the get activity events endpoint. Not sure if that has changed at all as it is been a while.  

[svenchio]

Thanks for the follow up @tayloramy  appreciate the help and comments, see you around 😉 al the best 

[svenchio]

Thanks @tayloramy  for this information, I'll check on thir right off to see how it works! I'll keep this post open for other people interest in the topic to contirbute... but I'll make sure to mark your as a solution 😉 ... all the best. 

[lbendlin]

The safest and most efficient way is to use the scanner API to do daily JSON extracts (feel free to put these into a data lake or DWH).  The caveat is that these extracts only go down to report level, not report page level.

[svenchio]

Thanks @lbendlin  just to confirm, is this what was on your mind? Scan Fabric Workspaces With Scanner API Using Semantic Link Labs or this Metadata scanning overview - Microsoft Fabric | Microsoft Learn ? Thanks for sharing