Forum Discussion
Power query first row data disappeared for no reason
I have come across a very strange situation where the first row of data disappeared for no reason in the next step (no matter what opertion it is) in Power Query. Please see below snips. I have tri...
I have 3 rows of data with the order of "Date", "Planner", and "Work Description" which repeat every week. The I transformed the data into rows of data with Date, Planned and Work Description each row. The first row (date) somehow disappeared so I had to drop another two rows so the first row would start from date for the next week. As can be seen, the date row with index 4 in previous step changed to index 3 without anything being done. It is very odd.
Hope this makes sense.