Forum Discussion

SignorSoprano's avatar
SignorSoprano
Icon for Helper I rankHelper I
2 years ago

Appending queries containing random number generation is super slow (never finishes)

I am trying to append multiple queries together as one big table. There are 6 tables to append and 5 of them are created by randomly choosing rows from the first table and then doing some minor trans...
General Comment
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi SignorSoprano 

You can consider to use Table.Buffer to store the table data in memory, you can refer to the following link about the function.

Table.Buffer - PowerQuery M | Microsoft Learn

 

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • SignorSoprano's avatar
    SignorSoprano
    Icon for Helper I rankHelper I
    2 years ago

    Yea. I have seen many a person suggest this and I don't know if it actually works for most people, but every time I have used this buffering, it slows down my queries tremendously! It seems useless in my use cases. But, just for kicks, I tried it and it does nothing to help speed up my query.

     

    Perhaps I should move the work to a Python script?