cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bkling
New Member

Expanding Merged Query to select desired columns pulls in duplicate rows of data

  1. I am using one Excel workbook, connecting to Power BI and pulling in 3 worksheets.
  2. Two of the worksheets have exactly the same columns, just different rows, so I used Append to put them together
  3. Great, Power BI says I have 384 Rows
  4. Now from the third worksheet, I want to use a common data point (email address) and have it look through a much larger number of rows, pulling in 2 columns I want to add to my Query. I create a Merged Query (using Left Outer) - great, still have 384 rows.
  5. BUT, when I try to expand the created column to pick which columns I want to bring in, it creates a bunch of duplicate rows, now I have over a thousand, many rows of completely duplicate data. I only want it to use my desired 384 rows, just pulling in matching rows with the 2 extra columns of data I want.

What am I doing wrong?

 

I saw this thread but it is not my issue: https://community.powerbi.com/t5/Desktop/Expanding-columns-after-a-Query-Merge-increases-number-of-r...

1 ACCEPTED SOLUTION
v-chuncz-msft
Community Support
Community Support

@bkling,

 

You'll need to remove duplicates in the third worksheet. If necessary, you can modify code in The Advanced Editor.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-chuncz-msft
Community Support
Community Support

@bkling,

 

You'll need to remove duplicates in the third worksheet. If necessary, you can modify code in The Advanced Editor.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors