Forum Discussion
Very simple 'Remove Duplicates' not working
I need to very simply remove duplicates for one column in a query. I want that one column to be the matching ID so I can match a 'many-to-one' relationship. I have tried doing all of the below step...
I received a couple email requests to send the PBIX out. As I was trimming down the 77mb file to a more manageable size, I tested the data in excel and also change my query. There definitely was duplicates in that column. I have fixed the problem by removing the 'Group By' function in the SQL code. I did not know Power BI would retain that 'group by' functionality after data had been retrieved. This makes me wonder what else Power BI retains from SQL code.
Greg_Deckler
Community Champion
Community ChampionSometimes this involves upper and lower case issues. I'd be interested in seeing example/sample data if you want to send in a private message.