Power BI remone duplicates records in Merge Queries with left Outer Join

[dheeraj_pareek]

Hi,

I have two tables in database "Table1" and "Table2". The common column between these tables is "serial number".

"Table1" has 1 record in table with value "serial1" in column "serial number".
"Table2" has 4 records in table with value "serial1" in column "serial number".

When we create a "Merge queries as New" between "Table1" and "Table2" on common column "Serial number" using "Left Outer Join", It returns 1 record with column "Serial Number" with value "serail1".

It display only unique records.

If we tried the "Left outer Join" between "Table1" and "Table2" using common column "Serial number" it returns 4 records with value "serail1" in column "Serial Number".

It seems Power Bi automatically removed the duplicate records while Merging Or Joins.

Is there any option to turn off this functionality?

Is there any way so that we can get also 4 rows by using Left Outer Join result in power BI also like Sql query executed on sql server?

Thanks

[v-yulgu-msft]

Hi @dheeraj_pareek,

---

When we create a "Merge queries as New" between "Table1" and "Table2" on common column "Serial number" using "Left Outer Join", It returns 1 record with column "Serial Number" with value "serail1".

It display only unique records.

If we tried the "Left outer Join" between "Table1" and "Table2" using common column "Serial number" it returns 4 records with value "serail1" in column "Serial Number".

What is the difference between above two options?

Based on my test, "Left outer Join" won't remove duplicates.

In merged table, expand the columns from the second table.

Best regards,

Yuliana Gu