Detailed usage metrics (report operations and filters)

[JoyH]

Hello!  

I have embedded a report into my application. It has 4 pages and 30 visuals. 

I have set up the Capacity Metrics app and I've made a copy of the report's Usage Metrics.

Both are OK, but I really need to delve into how our users are interacting with the reports. Specifically, I need to see

1. which report pages they are visiting (This is available in the Usage Metrics report but I'm not sure how they are getting it into the semantic model)
2. which visuals they are interacting with (drilling/clicking)
3. which slicers and filters they are using

Does anyone know how I would find those 3 datapoints?

I have started a very simple KQL query below.

PowerBIDatasetsWorkspace
| where TimeGenerated > ago(1h)
// | where OperationName == "VertiPaqSEQueryBegin"
| where ArtifactName == "Dashboard_PRODUCTION"
| project TimeGenerated, OperationName, OperationDetailName, ExecutingUser, Identity, ApplicationContext, EventText

[JoyH · Accepted solution]

Figured it out. Posting in case it helps someone else some day.

KQL:

PowerBIDatasetsWorkspace
| where TimeGenerated > ago(3h)
| where OperationName == "QueryEnd"
| where ArtifactName == "Dashboard_PRODUCTION"
| extend ParsedContext = parse_json(ApplicationContext)
| extend ParsedIdentity = parse_json(Identity)
| project ReportId = ParsedContext.Sources[0].ReportId, VisualId = ParsedContext.Sources[0].VisualId, TimeGenerated, EventText, ParsedIdentity.effectiveClaims.upn, Role = tostring(ParsedIdentity.effectiveClaims.roles[0])

I also loaded the .PBIP report.JSON file into PowerBI and parsed the visualID and visualName (had to make sure all the visuals had a good name in the Selection pane). 

Join visualID to VisualId and voilà, I can see the visual by user usage. Now I'm seeing if there are multiple EventTexts (DAX query) for that visual for that session... which will indicate user action.

If anyone has already done this work and has a PBIT they'd like to share, stop me now 🙂