Forum Discussion

Keezz's avatar
Keezz
Icon for Helper I rankHelper I
1 year ago
Solved

My data sorts correctly in preview but totally different when loaded to Excel

Just checking if this is a known bug, If it isn't I'll investigate further or supply more details.   Here is what happens: My Table has 66 rows I add an index form -1 by -1 I do a merge with fu...
Need Help
  • Deku's avatar
    Deku
    1 year ago

    Try adding a table.buffer() at the end of the query to cache the results

ZhangKun's avatar
ZhangKun
Icon for Super User rankSuper User
1 year ago

If it is not the first time to load into the table, the data will be sorted according to the settings on the table after loading.

If it is the first time to load, or the keep sort option of the table is turned off, it should be in the order displayed in the Power Query interface.

 

If none of the above conditions are met, this may be a bug. However, it is not ruled out that some operations may be optimized by Power Query, resulting in different displays in Power Query and Excel.

Keezz's avatar
Keezz
Icon for Helper I rankHelper I
1 year ago

Hi ZhangKun thanks, but I had already tried that. I removed the table and even removed the columns of the worksheet where the table used to be. After editing the load-to and re-creating the table, same problem!