topic Re: Log Analytics KQL - How do I track interaction? in Developer

Log Analytics KQL - How do I track interaction?

JoyH — Fri, 15 Mar 2024 19:23:28 GMT

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])

Re: Log Analytics KQL - How do I track interaction?

Anonymous — Mon, 18 Mar 2024 02:37:56 GMT

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

Re: Log Analytics KQL - How do I track interaction?

JoyH — Wed, 27 Mar 2024 15:38:33 GMT

Thank you!