SOLVED
Home

Export Analytics data to Excel Application Insights Analytics

%3CLINGO-SUB%20id%3D%22lingo-sub-182029%22%20slang%3D%22en-US%22%3EExport%20Analytics%20data%20to%20Excel%20Application%20Insights%20Analytics%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-182029%22%20slang%3D%22en-US%22%3E%3CP%3ETrying%20to%20export%20Application%20Insights%20Analytics%20data%20to%20excel%20%3F%20Is%20there%20any%20way%20of%20doing%20it%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-182029%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EApplication%20Insights%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAzure%20Log%20Analytics%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-221859%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20Analytics%20data%20to%20Excel%20Application%20Insights%20Analytics%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-221859%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%0A%3CP%3EThe%20simplest%20way%20to%20export%20data%20from%20Log%20Analytics%20to%20a%20storage%20account%20is%20to%20create%20Azure%20Function%20or%20Logic%20App.%20Azure%20function%20will%20purely%20be%20a%20code%20where%20with%20Logic%20App%20you%20have%20some%20out%20of%20box%20activities%20like%20executing%20Log%20Analytics%20query%20(to%20get%20the%20data)%20and%20create%20blob%20on%20Azure%20storage.%20My%20recommendation%20though%20is%20to%20not%20try%20to%20export%20big%20amounts%20of%20data%20as%20probably%20will%20be%20costly%20and%20time%20consuming.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-219053%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20Analytics%20data%20to%20Excel%20Application%20Insights%20Analytics%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-219053%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIs%20there%20an%20option%20to%20continuously%20export%20data%20from%20Analytics%20to%20any%20storage%20account%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThanks%2C%3C%2FP%3E%0A%3CP%3EChaitanya%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-183265%22%20slang%3D%22en-US%22%3ERE%3A%20Export%20Analytics%20data%20to%20Excel%20Application%20Insights%20Analytics%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-183265%22%20slang%3D%22en-US%22%3EExport%20often%20doesn't%20work%20from%20Log%20Search%20in%20my%20experience%2C%20though%20if%20I%20open%20the%20query%20in%20Advanced%20Analytics%20I%20can%20export%20without%20issue%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-182996%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20Analytics%20data%20to%20Excel%20Application%20Insights%20Analytics%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-182996%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20very%20much.Simple%20the%20button%20was%20in%20disabled%20mode%20when%20I%20checked.Later%20found%20that%20when%20the%20query%20is%20executing%20it%20was%20disabled%20once%20the%20result%20came%20it%20is%20enabled%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-182987%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20Analytics%20data%20to%20Excel%20Application%20Insights%20Analytics%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-182987%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%0A%3CP%3EThis%20option%20is%20available%20in%20the%20Analytics%20portal%20of%20Log%20Analytics%20or%20Application%20Insights.%20See%20screenshot.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Deleted
Not applicable

Trying to export Application Insights Analytics data to excel ? Is there any way of doing it ?

5 Replies
Solution

Hi,

This option is available in the Analytics portal of Log Analytics or Application Insights. See screenshot.

 

 

Thank you very much.Simple the button was in disabled mode when I checked.Later found that when the query is executing it was disabled once the result came it is enabled 

Export often doesn't work from Log Search in my experience, though if I open the query in Advanced Analytics I can export without issue

Hi,

 

Is there an option to continuously export data from Analytics to any storage account?

 

Thanks,

Chaitanya 

Hi

The simplest way to export data from Log Analytics to a storage account is to create Azure Function or Logic App. Azure function will purely be a code where with Logic App you have some out of box activities like executing Log Analytics query (to get the data) and create blob on Azure storage. My recommendation though is to not try to export big amounts of data as probably will be costly and time consuming.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies