Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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

az38's avatar
az38
Community Champion
6 years ago

Hi Anonymous 

are you sure its exactly the same items?

did you try trim it before grouping?

 

do not hesitate to give a kudo to useful posts and mark solutions as solution

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    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
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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