Forum Discussion

Shivanky123's avatar
Shivanky123
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Not able to export complete data in PowerBI from AppInsights

Problem:
I am exporting data from application insights to Power BI using advanced query editor. On my local Power BI Desktop, partial data is getting exported.

 

Objective:

The overall objective is to export data completely after query ran successfully.

 

Following scenario:

1. Ran query on AppInsights. It worked fine, resulted in data (say around 4L rows)

2. Exported same query to Power BI query using appInsights export tool

3. In PowerBI Desktop, pasted same query in Power Query advanced editor

4. It resulted in exporting partial data (say around 2.5L rows)

 

Points noted:

I've checked there is no issue of row limits/column limits and no storage issue (enough memory is available to accomodate data)

I've tried refreshing the data as well multiple times, the count increases but complete data is not getting exported .

 

I am looking for advice.

Thanks in advance.

Need Help

1 Reply

  • artemus's avatar
    artemus
    Icon for Microsoft Employee rankMicrosoft Employee
    5 years ago

    Have you tried using the AzureDataExplorer data connector, instead of using the export to query option? To do this, go to Get Data (or New Sources) -> More... and search for "Azure Data Explorer (Kusto)". This way of loading the data is more supported.