Hi!
I have 2 queries from SharePoint List, which both have Record (it comes from Lookup column in SP list)
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?
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