Visual data Export to Excel is removing lines

[RicardoV2]

Hello,

I have a table visual with something like 19430 lines being shown, I've verified on the report, and that same number appears in Excel online when using Analyze in Excel. Though that, when i do the export of table data's visual to Excel, exactly with the same filters, only 18740 lines are being exported.

Meanwhile I've seen Export data from a Power BI visualization - Power BI | Microsoft Learn , tried to change option in Options \ Current File Report Settings \ Export Data to the 2nd option but # lines in export is the same, and also just showing 6 columns 

 So, what can be happening here?

Thanks

[parry2k]

@RicardoV2 If there are duplicate rows it will show as one row and that might be the reason that it is showing fewer lines. Try this: add an index column in Power Query and then bring this index column in the table visual (no summarize) and then check. It will make each row unique.

[RicardoV2]

Hello @parry2k  , I've verified in multiple ways: by changing table columns from "Don't Summarize" to "count", to creating a calculated column with value 1 and summing it, and also online in "Analyze in Excel". 

I'm using only columns.

[parry2k]

@RicardoV2 how you verified 19430 rows? Do you have only columns or there are measures as well on the visual you are trying to export from?

[RicardoV2]

Hello @parry2k  , I've verified in multiple ways: by changing table columns from "Don't Summarize" to "count", to creating a calculated column with value 1 and summing it, and also online in "Analyze in Excel". 

I'm using only columns.