Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
mihaigm
Frequent Visitor

Help Needed! Appending 2 tables creates empty columns

Hello everyone here, and nice to be part of your community!

I'm working on a PowerBi file and I'm trying to append 2 tables with 3 columns each, but the result is a table with 6 columns ( the top half of the table has the first 3 columns with data and than other 3 columns with "null" data, meanwhile the bottom half of this new created table has the first 3 columns with "null" data and the next 3 columns with the real data in it... Why is that happening?? I did it several times, but the result will not change....

I just hope I managed to explain my problem somehow...

 

What should I do??  

Thak you so much in advance!

 

This is my first table...

mihaigm_2-1710862816295.png

 

This is my second table...

mihaigm_1-1710862798944.png

 

And this is the result...🤔   ...   I swear I used the "Append" button and not the "Merge" one!!

mihaigm_3-1710862860576.png

....the second half of my appended table:

mihaigm_0-1710863242003.png

 

 

 

1 ACCEPTED SOLUTION
Ahmedx
Super User
Super User

this is because your column names in two tables are different from each other
you need to rename the name so that it is the same

View solution in original post

2 REPLIES 2
mihaigm
Frequent Visitor

Thank you so much @Ahmedx !!!! It was so simple and yet so tricky!!! 😎 

Have a great day!!

Ahmedx
Super User
Super User

this is because your column names in two tables are different from each other
you need to rename the name so that it is the same

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors