Divergence with data extraction function in visual with downloaded XLS file

[WillRanzani]

I have a table with 73.565 lines

When i use the Export Data button and generate the XLSX file (with 150k lines limit), the file "swallows" some lines of the table, bringging 73.556 lines (9 lines disapear from the table).

has this ever happened to you?

[v-eqin-msft · Accepted solution]

Hi @WillRanzani ,

You have to consider that

1. the table may automatically aggregates some data.

2. did not show rows that have no data.

3. exist exactly the same rows.

For this reason you may have to tweak your table visualization a little

• Don't summarize 
• Show items with no data

• Add a Index column

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[WillRanzani]

Bringing*