Export to excel doesn't export all records

[vidyadutt]

I'm trying to export data from a table visual, which has 8000+ records, however the exported excel (and also csv) has only 2000+ records.

Then I added an index column (Edit Query --> Add Column --> Index Column --> From 1), and added the index column to the table visual. After that when I export to excel, I get all records in excel (also in csv).

The problem exist in both Desktop and Service.

Anyone experienced this issue and know any solution?

[v-eachen-msft]

Hi @vidyadutt ,

Index column means every row is unique. So you could check if you have the same rows. And check every column is not summarized.

[vidyadutt]

Hi @v-eachen-msft,

The rows are not the same, there are no duplicates. And I'm not summarising columns either. The problem is when I export I don't get the same data that I see in the report.

Regards,

Vidyadutt

[az38]

@vidyadutt 

dont you have any aggregations in the fields in visual pane?

[vidyadutt]

Hi @az38,

No. No aggregations are done on the datasets.

Regards,

Vidyadutt

[Pragati11]

HI @vidyadutt ,

Are there any filters on your report before exporting data?

Thanks,

Pragati

[vidyadutt]

Hi @Pragati11 

No, no filters were applied when I exported the data.