Forum Discussion
bkling
8 years agoNew Member
Expanding Merged Query to select desired columns pulls in duplicate rows of data
- I am using one Excel workbook, connecting to Power BI and pulling in 3 worksheets.
- Two of the worksheets have exactly the same columns, just different rows, so I used Append to put them together
- Great, Power BI says I have 384 Rows
- 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.
- 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-rows/m-p/40389#M15168
You'll need to remove duplicates in the third worksheet. If necessary, you can modify code in The Advanced Editor.
1 Reply
- v-chuncz-msft
Community Support
You'll need to remove duplicates in the third worksheet. If necessary, you can modify code in The Advanced Editor.