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.