cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TamilselviK
Frequent Visitor

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
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors