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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
TamilselviK
Helper I
Helper I

Merge Expand Issue

I have two 2 Tables Table 1 contains - 30K and Table 2 contains - 169 data when i merged(Left Outer join) it  now the table contains 2L rows. I am not sure where it went wrong

5 REPLIES 5
Fowmy
Super User
Super User

@TamilselviK 

Not enough information to understand what exactly is the issue. 

Can you load the results to Power BI by click on the Apply and Load button and check how many records are there if your question is about the number of records getting materialized?

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

@TamilselviK 

 

When you merge in Power Query, all the matching rows of the referenced table are presented for you to either keep it as a table and expand or aggregate a certain column as sum or count. 

You can get just one value by tweaking a small code as shown in this article:  

 

https://www.google.com/amp/s/www.antaresanalytics.net/amp/2019/04/06/power-query-merged-tables-aggre...

 

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

@Fowmy 
When i do the VLOOKUP in excel row count remains same for ex: If i do VLOOKUP table1 and table 2 - Table 1 count remains same it will not get  added up, but when i do the merge in Power BI and exand it i could see row count more than what i should have.

I have used Count Rows activity to know the Rows count before and after merge that is were i found this issue.

I'm new to Power BI so i am not sure where it went wrong

 

Hi  @TamilselviK ,

 

If you do the merge by "left outer",there shouldnt be extra rows.As shown below:

v-kelly-msft_0-1623133466679.png

Merged table should have the same row count with the left table before merging.

Could you pls paste some screenshots of your steps and issues for check?

 

Best Regards,
Kelly

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

 

@TamilselviK 

Not clear about the situation you are facing issue with. Can you create a sample Power BI file with the scenario and share it here?

You save on OneDrive, any other source then sharer the link.


Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors
Top Kudoed Authors