Append not showing expected data

Hi all,

I am new to PowerBI. I am trying to Append some data fetch from D365 Business Central(cloud). I have fetched Vendor Ledger Entries for all companies and added "Company" column. After that i am trying to create New Append on tables. I am getting different results on ecah refresh of Preview.

Here are the tables

Vendor Ledger Entries for 2 companies 4 rows

Vendor Ledger Entries for 2 other companies 3 rows

Here is the Appended Table(6 rows instead of 7 and unrelevant data showing up repreating from top row from top table)

Please let me know why this is happning. I have cleared Cache many times to no avail. Also tried to make all column types same in all tables but issue remains same.

Regards