Forum Discussion
Data deleted on expanding merge query
An issue came up when I merged information from another query into an existing query (JoinKind.LeftOuter or equivalent to a vlookup in Excel) where, upon expanding the merged query, rows were inexpli...
ImkeF
Community Champion
Community ChampionHello CRamstedt ,
haven't heard of this problem before.
Please keep in mind that the order of the rows will not be kept after the column expansion. So when checking for matches, you must consider the whole row.
Hi Imke,
Thank you for the response, however, I have considered the whole row, so this does not address the issue.
After doing a search, I found the following thread addressing this issue and was wondering if there is an update to the bug.
https://community.powerbi.com/t5/Desktop/Power-Query-Row-disappear-after-expand-column/td-p/643967
Kind regards,
Christina