none
Power Query - Row disappear after expand column RRS feed

  • Question

  • Hello,

    I have encountered a strange thing when I expand merged table column.

    I use JoinKind.LeftOuter to merge queries - that should keep all the rows from the first/left table - and it does.

    But when I expand the column I loose 2 out of 719 rows. How is that possible?

     

    Here is a gif with only 2 filtered rows, but it shows the behavior:

     

     

    expand2.gif

     

    the table contains personal details so I cannot share it or show more columns but it is always the SAME PERSON that disappears after expanding.

     

    EDIT:

    I wanted to add a custom column showing the row count of the expanding table, but after this step, the row DOES NOT disappear:

     

    expand3.gif

     

     

     

    Any explanation please? I really don't understand that and it really scares me that I might be loosing rows in my other queries!

    (the same thing happens in Power Query Excel)

     

    Warm regards

    Jakub

    Wednesday, March 13, 2019 12:08 PM

Answers

  • Thanks Jakub for reporting this issue.

    We are working with Jakub to investigate this issue via email.

    • Marked as answer by jakub dusek Friday, March 15, 2019 3:10 PM
    Friday, March 15, 2019 12:07 AM

All replies

  • Hi Jakub,

    In case of such weirdnesses, there is possibility, that clearing cash may solve the problem.

    Wednesday, March 13, 2019 1:49 PM
  • Hi Jakub.

    Sometimes this bug appeared. You also can try to add an index column or perform Table.Buffer on target table, or on both tables before join. Try different ways


    Maxim Zelensky Excel Inside

    Wednesday, March 13, 2019 5:05 PM
  • Hello,

    unfortunately I cannot share sample data - the source data is pulled from ACCESS db.

    when I try to store sample data in Excel table, the problem does not occur.

    Clearing Cache did NOT help.

    Table.Buffer did help:

    

    I want to know how this happens? How can this basic merge/join feature be so unreliable?

    Does it mean that I have to go through all my queries (dozens) and check if Power Query did not eat rows?

    Warm regards,

    Jakub


    • Edited by jakub dusek Thursday, March 14, 2019 12:04 PM
    Thursday, March 14, 2019 11:51 AM
  • Thanks Jakub for reporting this issue.

    We are working with Jakub to investigate this issue via email.

    • Marked as answer by jakub dusek Friday, March 15, 2019 3:10 PM
    Friday, March 15, 2019 12:07 AM