Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
syasmin25
Helper V
Helper V

Merging Query in increasing rows

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:tbruh.PNGClasses Table:
tbruh.PNG

 Merge Tables tbruh.PNG

 

 

 

7 REPLIES 7
camargos88
Community Champion
Community Champion

Hi @syasmin25 ,

 

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

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

 



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



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.

@syasmin25,

 

Can you share a sample of it on a PBIX ? 

So we can take a look.



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



I do not have the option to do that here.

@syasmin25 ,

 

You can use GoogleDrive/OneDrive/DropBox.



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



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

Hi, can you tell me what happened exactly with your database? looks like I have similar issue with you.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.