Join issue

[saranee]

Hi all,

Request your help on this:

We have two tables table 1 and table 2 .Table 1 has 1 to many relationship with table 2 .We need all the records from table 1 .While doing  join between these 2 tables, table2(table in many side) is becoming the left table  and table 1(table in 1 side) is becoming the right table.So can not get all the entries from table 1.I have tried doing this in edit query but there also no luck .

Please can you suggest.

Thanks,

saranee

[v-shex-msft · Accepted solution]

HI @saranee,

You can refer to following blog which told about table join.

Merge Tables using Outer Joins in Power Query

Regards,

Xiaoxin Sheng