Power Query Slow Refresh - Many Record and Table

Like (0) Share

Report

Posted on 7 Aug 2023 04:06:55 by reyaldi7

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?

All responses (1)

Answers (0)

reyaldi7 72 on 07 Aug 2023 at 06:22:32

Like (0)

Report

Re: Power Query Slow Refresh - Many Record and Table

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