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...
If you didn't intend to drop rows 1 and 2 then you must've accidentally clicked something, because that's what your code is telling it to do.
The strange thing is I did not click anything. I used the same code for mutiple work sheets and they all woked well except this one. In order to get the correct data after transformation, I had to do a workaround by droping two rows so the first row will start from Date again as the transformation codes only work correctly on the order of Date, Planner and Work Description.