Merge queries

[Anonymous]

I need to merge two tables each with many of the same headers but totally different records on each row. So if I have 1,000 records in one table and 500 records in another table, the merged table will have 1500 records. I used merge queries and selectedall of the common headers. I get a new column to the right of the existing table with a table icon in it. What do I do next to combine the records? I have tried expand and aggregate but it does not merge theindividually different records. Sorry I am new and I am just not getting this.

[v-danhe-msft]

Hi @Anonymous,

From your description, I guess you want to merge two tables with different numbers of rows, right? If so, you could refer to below steps:

1.I have entered some data to test for your problem like the picture below:

2.Create a new merge table and choose the Join Kind with “Full Outer(All Rows)” .

3.Expand the table and you can see all the records.

You can also download the PBIX file to have a view.

https://www.dropbox.com/s/h2o42xsy7qdf5wt/Merge%20queries.pbix?dl=0

Reference:

http://radacad.com/append-vs-merge-in-power-bi-and-power-query

Regards,

Daniel He

[Anonymous · Accepted solution]

I used Append as New and it worked. Thanks for the solution!