Append not showing expected data

SaghirAlam — Wed, 29 Jan 2020 10:31:55 GMT

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

topic Append not showing expected data in Developer

Append not showing expected data