Export data from application insights to Azure storage in csv format

Rushank 1 Reputation point


I am currently exporting data from application insight to azure blob storage in JSON format and then export this data from azure storage to powerbi.

Application insights -> Azure storage-> PowerBI

But i am facing json file format error, is there i a way to store in azure blob storage in csv format

Thank you257941-json-error.png

Azure Monitor
Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
2,645 questions
Azure Storage Accounts
Azure Storage Accounts
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
2,504 questions
Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
2,262 questions
Not Monitored
Not Monitored
Tag not monitored by Microsoft.
34,779 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Ryan Hill 24,121 Reputation points Microsoft Employee

    @Rushank ,

    It's difficult to say what is preventing you to load your exported application insights data from a storage account.

    To my knowledge, you cannot specify a format into how to export application insight data. Also note that application insight telemetry export will be deprecated in one year 3 months. Therefore, I would advise migrating your application insights to a Log Analytics workspace if you haven't done so already and export the data from there.

    I suggest opening the file directly from storage into an editor like VS Code. This will confirm the file itself hasn't been malformed. Next, I would attempt to open that file from Power BI to ensure there isn't an issue with the connector. If that works, then your issue might be more Power BI related (like an issue with the connector) in which reaching out to that community may be beneficial.

    0 comments No comments