Most efficient way to combine tables

[Anonymous]

Hello,

I'm looking to create a list/table that combines a couple fields from three existing tables, and creates a full list of those details, without duplicates. For example, we'd want to join Table A, B and C to create Table D (see below). What is the most efficient way to do this in PowerBi? 

Thanks!

[Einomi]

If you the tables you want to append (combine) have the same headers, then you can use the Append table feature

Then select all your new table and you can easily remove duplicates

Give it a try and if you need more help, I'll be happy to help more

[Einomi · Accepted solution]

let
    Source = Table.Combine({Table_A, Table_B, Table_C}),
    #"Doublons supprimés" = Table.Distinct(Source)
in
    #"Doublons supprimés"