Power Query : Maximum Append Rows 5000 Rows

[muhammad susanto]

hi sandy, my problem when i running power query so slowly for when append data 1 million rows...the fact, my data rows not reach 1 million just approx 3000 rows
i don't know what happen with my files...i have clear unnesesary rows and cleaning formatting
all my excel file in the same format..i'm using Excel 2013..
it happen only for 2 files the other file is normally ...it's mean if the file contains 3000 rows after append 3000 rows too..

[sandy666]

Hard to understand, but check for column names (must be exactly the same) .Power Query is case sensitive
Maybe check data types also
Excel 2013 using Power Query add-in and this is not the best choice. I suggest Excel 2016 or higher
On the end I suggest attach these 5 files. If there is sensitive information use generic data