How to export data from Application Insights?

Question

How to export data from Application Insights?

Swathi R S 21

Hi,

Now that we don’t have continuous export data , how to easily export application insights data to excel and JSON form?

Regards,
Swathi

1 answer

Your answer

Answer 1

bharathn-msft 5,106 Microsoft Employee Moderator

<<Resurfacing the information from comments for broader community usage >>

Hello @Swathi R S - Welcome to Microsoft Q&A and thank you for reaching out with your query.

Regarding your ask, have you already reviewed the option to export to excel from the Application insights --> Logs . However the export format in excel is not JSON form, you might have to do some customization on excel data to make that happen.

However specifically if you need in JSON form , the events you see in the Application Insights portal can be exported to storage in JSON format. From there, you can download your data and write whatever code/format you need to process it.

Also for additional details on exporting telemetry from Application Insights, please refer to this documentation. Let us know if you have any further queries.

Swathi R S 21 Reputation points

2021-06-24T06:12:18.227+00:00

Hi,

I am trying to export to Azure Storage. I am not able to find my storage account listed.
bharathn-msft 5,106 Reputation points Microsoft Employee Moderator

2021-06-29T18:59:08.693+00:00

@Swathi R S Apologies for delay in getting back to this thread. The storage account don't show up if there are no storage accounts or you don't have permissions on the storage accounts in that subscription. Can you please help confirm that you have storage account in the "Azure for students" subscription or create a new one and see if it shows up ?

There are some exceptions for Azure Data Lake Storage Gen2 , which has been called out in this document. Please see if you are getting in to this scenario. Thanks

Looking forward to hear back from you. Thank you
bharathn-msft 5,106 Reputation points Microsoft Employee Moderator

2021-06-30T22:09:22.607+00:00

@Swathi R S Following up to see if you have a chance to review above comment and have any other information you can share with us to further help you. Thank you
Swathi R S 21 Reputation points

2021-07-07T11:02:31.467+00:00

Hi, I have used Diagnostic Settings. But can you please provide me details of how can i see the JSON data in my storage account?

Thanks
Swathi R S 21 Reputation points

2021-07-09T01:56:47.95+00:00

@bharathn-msft please reply
bharathn-msft 5,106 Reputation points Microsoft Employee Moderator

2021-07-09T02:51:44.727+00:00

@Swathi R S - Apologies for the delay in getting back to your earlier follow up, reviewing your query. Will get back to you at the earliest.
bharathn-msft 5,106 Reputation points Microsoft Employee Moderator

2021-07-09T06:05:55.387+00:00

@Swathi R S Assuming you have enabled the diagnostic setting within Application Insights as below.

Once that's the enabled and you start using the application and which would ingest the telemtery data into Application Insights and that would also go into storage account.

Go to the storage account you have configured earlier and with in that navigate to containers of the storage account and you should see something below

For example you can pick the insights-logs-apprequests container and navigate through the location until you see PT1H.json file

You can further download the file

Hope this information helps. Please feel free to revert back if you have any further queries. Thank you

Share via

How to export data from Application Insights?

1 answer

Your answer