Hi @Toral Patel,
To merge rows from two data tables without duplication without matching key in PowerPivot, you can use the "Append Queries" feature. First, create a connection to each table in PowerPivot. Then, go to the "Power Query Editor" and select the first table. From the "Combine" dropdown, select "Append Queries". In the "Append Queries" dialog, select the second table and click "OK". This will append the rows from the second table to the first table without creating duplicates. Finally, load the combined query into PowerPivot and create a PivotTable from it.
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.