Merging with another file results in more lines added

[Sanjica]

I have a file with 2,333 rows loaded in the data model. I merge with another file and suddenly have 2,700 rows loaded. Where are these additional rows coming from?

[v-xjiin-msft]

@Sanjica

To troubleshoot your issue, you can refer to following article:

https://community.powerbi.com/t5/Data-Stories-Gallery/Visualizing-Merge-Join-Types-in-Power-BI/m-p/2... 

Thanks,
Xi Jin.

[Vvelarde]

@Sanjica

Hi, check what Join Kind do you use.

Regards

Victor