Merging Query in increasing rows

[syasmin25]

Hello, 

I am trying to merge two tables to get 3 columns from the other table and it is creating 4 additional duplicate rows (in the actual report, which has led to more than 2 million rows). I have created a sample here and it even did the same thing to that. I was wondering if somebody could help me out here. I am doing a left outer join and have made sure that the tables do not have duplicates beforehand. 

I am attaching screenshots of my sample file here, 

Attendance Table:Classes Table:

 Merge Tables 

[camargos88]

Hi @syasmin25 ,

Are you merging them with unique id's per row ?

If not they are gonna replicate the rows from the outer table.

[syasmin25]

In the original file, I have created a ID.Bellperiod index column in both the tables and I am trying to merge based on that.

[camargos88]

@syasmin25,

Can you share a sample of it on a PBIX ? 

So we can take a look.

[syasmin25]

I do not have the option to do that here.

[camargos88]

@syasmin25 ,

You can use GoogleDrive/OneDrive/DropBox.

[syasmin25]

I figured it out. It was an issue within the database.