Forum Discussion
Power Query not sorting Properly (Excel 2013)
Hello all, I am new to these forums so forgive if I am doing anything wrong. I have come across a problem with Power Query in Excel 2013. I am importing from a Table in a different Excel workbook, ...
Hi Peter,
That could be bit abstract without knowing the details of you model, however,
- on PQ site try to isolate your table in memory using 'Add this data to Data Model' in Load To options; or by using Table.Buffer() in M script;
- on Excel site right click on your table and in Table->External Data Properties be sure options are checked as you need, especially Preserve column sort/filter/layout
Hi Sergei,
Thanks a lot for your comments!
I have tha same issue of Peter. The sorting look correct in Query Editor Preview, however when I Load to table the sorting looks completely differentI noticed that sorting follows the ASCII codes, which is different from Excel's sorting behavior. Does it explain the unexpected sorting result?
