Forum Discussion

sidneyjacobs's avatar
sidneyjacobs
Frequent Visitor
4 years ago
Solved

GROUP BY in PowerQuery ignores 1 specific value

Hey everybody, I'm either missing something extremely obvious, or I've come across a bug in PowerQuery.   I'm creating a table of clients, their orders and the products in those orders. While tryi...
Need Help
  • sidneyjacobs's avatar
    sidneyjacobs
    4 years ago

    Dear Kelly,

     

    I'm still not quite sure why.. but after a few database loads and recreating the steps my problem went away. I guess I'm better off removing the topic since I can't reproduce the steps and pose a solution for other community members.
    Thank you for reaching out though!

    Sidney

sidneyjacobs's avatar
sidneyjacobs
Frequent Visitor
4 years ago

Hello Nate,

That's a good suggestion. I was a little unclear however: I used # to replace the actual value (think A0505483249) This is a mix of letters and numbers, never containing an escape character.

v-kelly-msft's avatar
v-kelly-msft
Community Support
4 years ago

Hi  sidneyjacobs ,

 

Could you pls paste some screenshots to let us check whether there is some missing details?

Remember to remove the confidential information.

 

Best Regards,
Kelly

Did I answer your question? Mark my raeply as a solution!

  • sidneyjacobs's avatar
    sidneyjacobs
    Frequent Visitor
    4 years ago

    Dear Kelly,

     

    I'm still not quite sure why.. but after a few database loads and recreating the steps my problem went away. I guess I'm better off removing the topic since I can't reproduce the steps and pose a solution for other community members.
    Thank you for reaching out though!

    Sidney

    • v-kelly-msft's avatar
      v-kelly-msft
      Community Support
      4 years ago

      Hi  sidneyjacobs ,

       

      If so,you could mark your reply as answered to close it.

       

      Best Regards,
      Kelly

      Did I answer your question? Mark my raeply as a solution!