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

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

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

  • v-aatheeque's avatar
    v-aatheeque
    Icon for Community Support rankCommunity Support
    1 year ago

    Hi Keezz ,

    we wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

     

    If our response has addressed your query, please accept it as a solution so that other community members can find it easily.

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

      v-aatheeque , you are a bit impatient, aren't you? I happen to have other duties beside Power Query work, so I hadn't had the opportunity to review...

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

    Thanks Deku , that did the trick!

    Is this considered to be a work-around for a bug? And if so, has this bug already been reported?

    • Deku's avatar
      Deku
      Icon for Super User rankSuper User
      1 year ago

      Not a bug, just how PowerQuery is implemented