Forum Discussion
Very simple 'Remove Duplicates' not working
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.
Community SupportAnonymous ,
After Selecting the column I want to remove duplicates on and Right Clicking that column --->
1.Remove Errors
2.Filtered Rows (blanks) [This probably isn't doing anything to help?]
3.Trimmed Text
4.Cleaned Text
5.Remove Duplicates
How do you trim the column? Please check if there's still some values in the column contains blank such as "#$%as1 ".
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.