Forum Discussion

RicardoV2's avatar
RicardoV2
Frequent Visitor
3 years ago

Visual data Export to Excel is removing lines

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 d...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
3 years ago

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.