Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I have two tables with data as below
table 1
| item | item2 | item3 | item4 | item5 |
| a2 | b2 | c2 | d2 | e2 |
| a3 | b3 | c | d3 | e3 |
| a4 | b4 | c | d4 | e4 |
| a5 | b5 | c | d5 | e5 |
Table 2
| product | product2 | product3 | item | item2 | item3 | item4 | item5 | product4 | product5 | product6 |
| 111 | 222 | 333 | 444 | 555 | 666 | 777 | 888 | 999 | 1110 | 1221 |
| 111 | 222 | 333 | 444 | 555 | 666 | 777 | 888 | 999 | 1110 | 1221 |
| 111 | 222 | 333 | 444 | 555 | 666 | 777 | 888 | 999 | 1110 | 1221 |
| 111 | 222 | 333 | 444 | 555 | 666 | 777 | 888 | 999 | 1110 | 1221 |
I want to add/append table 1 data to table 2 , where table 2 has same columns as table 1 with addtionals columns in it
so my final output should look like below
| product | product2 | product3 | item | item2 | item3 | item4 | item5 | product4 | product5 | product6 |
| 111 | 222 | 333 | 444 | 555 | 666 | 777 | 888 | 999 | 1110 | 1221 |
| 111 | 222 | 333 | 444 | 555 | 666 | 777 | 888 | 999 | 1110 | 1221 |
| 111 | 222 | 333 | 444 | 555 | 666 | 777 | 888 | 999 | 1110 | 1221 |
| 111 | 222 | 333 | 444 | 555 | 666 | 777 | 888 | 999 | 1110 | 1221 |
| null | null | null | a2 | b2 | c2 | d2 | e2 | null | null | null |
| null | null | null | a3 | b3 | c | d3 | e3 | null | null | null |
| null | null | null | a4 | b4 | c | d4 | e4 | null | null | null |
| null | null | null | a5 | b5 | c | d5 | e5 | null | null | null |
Solved! Go to Solution.
@Anonymous , if you append in power query this should happen
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
@Anonymous
Append in Power Query: https://1drv.ms/u/s!AmoScH5srsIYgYRHURu-etKZBRdZcw?e=sK0cEc
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi @Anonymous,
Go to the Power Query Editor, select Table 1, go to the Home Page and click Append Queries from the Combine section.
Choose Table 2 and click Ok.
After this you will see the proper output.
_______________
If I helped, please accept the solution and give kudos! 😀
@Anonymous , if you append in power query this should happen
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 66 | |
| 47 | |
| 43 | |
| 26 | |
| 19 |
| User | Count |
|---|---|
| 198 | |
| 126 | |
| 102 | |
| 67 | |
| 50 |