Different Row Count Power Query vs Data Visual Export

[Anonymous]

Hi all,

Using PBIRS Sept, 2021.

I added a row count after my last transformation in Power Query - 4,679. Remove Row Count. Close & apply.
Go to Report Canvas. Add a Table Visual. Addd the 4 Fields from the Table to the Visual. Export Data to csv. Open csv file in Excel. - 4,894 Rows.

Any thoughts why there would be a difference?
Have you seen this disrepancy before?

Thanks,
-w

[v-yalanwu-msft · Accepted solution]

Hi, @Anonymous ;

Probably because you have duplicate rows, I tested a simple case.

1.Orginal table.

2. table in report and export csv

So we could add index column.

Then export csv

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.