I have a Power Query that when I set it up originally saves the data to a data table in the same order as it shows when I look at the query output prior to the "LoadTo" step. I then changed the input (.csv) files for the query so that there is new data. When I do a refresh, the data loads into the Table on the tab as before but now the order of the rows on the Table in the tab is not the same as the order shown on the query just before the "LoadTo" step.
I don't know why the order has changed. I refreshed the query multiple times and it gives the same ordering of the rows in the table which again is different than what shows in the Query window. I can reorder the rows in the table with a sort command but I would like to know why this change of order occurs in case I am doing something incorrectly?
Any idea what might be happening to cause this?