Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
86 | |
85 | |
67 | |
49 |
User | Count |
---|---|
134 | |
113 | |
100 | |
68 | |
67 |