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
Helpful resources
Power BI Monthly Update - April 2026
Check out the April 2026 Power BI update to learn about new features.
Data Days 2026 coming soon!
Sign up to receive a private message when registration opens and key events begin.
New to Fabric Survey
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
