Log Analytics KQL - How do I track interaction?

[JoyH]

Hi,

I have a requirement to see which slicers and visual users are interacting with.

I have Log Analytics set up for my workspace and I am able to see a record for each dashboard visual load (KQL below). I'm importing this data into a PBIX and modeling it with report.JSON to get the names & descriptions of all the visuals.

My next step is to somehow figure out if a user changed a slicer or drilled into a visual or selected a value.  I'm hoping there is a better way to do this than comparing the DAX/EventText. 

If anyone knows, please reply. TIA!

PowerBIDatasetsWorkspace
| where TimeGenerated > ago(30d)
| 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])

[JoyH]

Thank you! 

[Anonymous · Accepted solution]

Hi @JoyH ,

Please try the following sentences:

Sample Log Analytics KQL queries

let dashboardName = "YourDashboardname";
PowerBI
| where OperationName == "VisualContainer" or OperationName == "Slicer"
| where ReportName == dashboardName
| where TimeGenerated > ago(30d)
| project TimeGenerated, OperationName, UserName, ObjectType, ObjectName, AdditionalInfo

Best Regards