Forum Discussion
Solved
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 G...
You'll need to remove duplicates in the third worksheet. If necessary, you can modify code in The Advanced Editor.
You'll need to remove duplicates in the third worksheet. If necessary, you can modify code in The Advanced Editor.