Forum Discussion
Sorting table in Power Query produces different results to sorting same table in Excel
I have a power query table that includes as it's last step a sort of rows based on 4 fields 3 of which are numeric data type. The query loads the table back into a worksheet. In the worksheet i h...
Your post filled me with hope! But when I followed your directions to the data model in excel there were no sorts applied to any of the columns so I'm still stuck with my table in power query and in excel in different orders.
Can you see if I'm missing something or do you have any other suggestions?
In External data properties setting Preserve column sort/filter could be ON
If data type is Any and data is loaded to data model, it will be considered as text and return to Excel as text. Iven if values are looks like numbers. With the Power Query will sort them as numbers and Excel as texts.
Perhaps something else, it's better to have small sample file which illustrates an issue for this concrete case.