Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Loading result different from the one in the power query editor

Hello everybody,

I used power queries to format a source file so that it can be imported into a software without manual reprocessing. For the import to work, the date and time must be in columns and the minutes (grouped by 10) must be in columns with the corresponding values below. All this in chronological order!
I managed to get what I wanted with the Power Query editor:

So far so good, but when loading the file, the order of the minutes changes and it is no longer usable for importing into my software:

I tried to sort the file in Power Query, but it doesn't work either.
Have you ever had this problem and if so, do you know what to do?

Thanks in advance,

Joël

3 Replies

  • mahoneypat's avatar
    mahoneypat
    Icon for Microsoft Employee rankMicrosoft Employee

    Have you tried adding an index column at the step where it is sorted correctly in the query editor?

    Pat

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hello,

      Yes I tried and the result is the same ...

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

     

    Is there any filter added that caused the data to be filtered out?

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.