How to use buffer

[TarynMiller]

Hi, My file is now taking ages to load, it's actually not too bad when I refresh but just going between steps in order to add in additional steps is painful!

I've read about table buffer, would this help? If so can anyone help me add this in? I'm very new to Power Query

FYI I've already turned off automatic previews

[v-jialongy-msft]

Hi @TarynMiller 

Here's a simple way to use Table.Buffer :

1. Identify the step in your query that you believe is being recalculated multiple times and is causing performance issues.

2. In the Power Query Editor, go to the Advanced Editor.

3. Find the step that you identified. It will look something like this:

YourStepName = SomeTransformationFunction(PreviousStepName),

4. Modify this step by wrapping the 'PreviousStepName' with the function 'Table.Buffer' , like so:

YourStepName = SomeTransformationFunction(Table.Buffer(PreviousStepName)),

Best Regards,

Jayleny

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

[PijushRoy]

Hi @TarynMiller 

Please go through the video - https://www.youtube.com/watch?v=xv5UxtUCOK0

Let me know if that works for you

If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush
Linkedin