Forum Discussion
Group By Power Query Not Working Properly
Hi, I am using Group By in Power Query and it is not working properly. Before using Group By, I have some duplicates of 2 and 3. After using Group By on multiple columns, it has now become 2. How...
I found out what the problem was. In Power Query, uppercased and lowercased letters are considered to be different, however, in Power BI, there are the same. That's why it appeared in Power BI table view as duplicates and group by didn't work on Power Query. After standardizing them, it worked correctly.
Thanks.
Daren
Hi az38
Although I didn't trim them, but I believe they should be the same because I did a count for duplicates and sorted them ascending. If the count is 2 it means the first two rows of the sorted table would be the same.
Daren
Although I didn't trim them, but I believe they should be the same because I did a count for duplicates and sorted them ascending. If the count is 2 it means the first two rows of the sorted table would be the same.
Daren
I found out what the problem was. In Power Query, uppercased and lowercased letters are considered to be different, however, in Power BI, there are the same. That's why it appeared in Power BI table view as duplicates and group by didn't work on Power Query. After standardizing them, it worked correctly.
Thanks.
Daren