One possible way would be to analyze the data with the Power Bi app from Microsoft
github.com/.../README.md
once the data is in there, you can easily use it in Excel as well
The advantage here, Microsoft has already created the PBI App with meaningful views. With Excel you can then dig in the data in details.
Other solution would be in azure directly via a query, as a simple example, follow these steps:
In the Azure portal, open your Application Insights resource.
In the Monitoring menu, select Logs.
On the New Query tab, type the following to get the recs
union isfuzzy=true
availabilityResults,
requests,
exceptions,
pageViews,
traces,
customEvents,
dependencies,
traces
| where timestamp > datetime("2022-01-01T00:00:00.001Z") and timestamp < datetime("2022-05-01T23:59:59.999Z") // change the timestamp to current month!
and itemType == "trace" and severityLevel > 1
| order by timestamp desc
and on the top there is in Azure
Export to csv
Export to Power Bi
Export to Excel
hope this helps
