Power Query Slow Refresh - Many Record and Table

[Syndicate_Admin]

Hi!
I have 2 queries, which both have Record and table.
Both queries will be appended after each query record and table are extracted.

The problem is, I feel like the query refresh very slow, even when i only have few data.
I do sort and filter first for each data to make data iteration faster since only small amount of row data will be extracted, but nothing happens.
Any idea?

[Syndicate_Admin]

Hi!
I'm still new with power query.
and after looking for some information, I get that the problem is expanding from another sharepoint requires http request for each row right?

but that's all I know,
i know nothing about Table.buffer even after learning it

[rubayatyasmin · Accepted solution]

You are right. Expanding data from SP or any other Web Based service may require HTTP request for each row. which could lead to slow performance. The more rows you have, the more HTTP requests are made which can be inefficient. 

I suggested Table.Buffer() thinking as this function, according to Microsoft creates an in-memory snapshot of your current table. I thought it could improve the refresh rate a little bit. Although the below thread, says this function doesn't always improve performance. 

you can go through this thread to know more about table.buffer().

From the official doc of Table.Buffer() from my previous comment, your code might look like,

let
    Source = ... (your SP data source code here),
    BufferedSource = Table.Buffer(Source),
    ExpandedData = ... (your expansion or other operations on BufferedSource)
in
    ExpandedData

https://www.myonlinetraininghub.com/excel-forum/power-query/how-to-use-table-buffer-please-help

[rubayatyasmin]

Hey, 

you can try to use Table.Buffer() to solve this problem. 

I found a similar thread that might be of help. 

https://community.fabric.microsoft.com/t5/Power-Query/Power-Query-taking-forever-to-load-or-refresh/....