Forum Discussion
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
Microsoft Employee
Have you tried adding an index column at the step where it is sorted correctly in the query editor?
Pat
- AnonymousNot applicable
Hello,
Yes I tried and the result is the same ...
- AnonymousNot 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.