Forum Discussion
Power Query slow refresh and TABLE.BUFFER
Hi , very much appreciate your help with this i have a workbook with 50 power queries, of which 30 need to refresh ALL, at the same time. some of them time out (i get the popular "this query doesn...
That could be like
step = Table.NestedJoin(
Table.Buffer( Class ), {"Column2"},
Table.Buffer( myid ), {"Trnid"},
"myid", JoinKind.LeftOuter)or
a = Table.Buffer( Class ),
b = Table.Buffer( myid ),
step = Table.NestedJoin(
a, {"Column2"},
b, {"Trnid"},
"myid", JoinKind.LeftOuter)Table.Buffer() do nothing but load the table into the memory.
thanks for this sergei, ill try it and hope it works.
if i could ask one further question of you,
what does the FAST DATA LOAD do on power query settings. i have always turned this ON. As i seem to get the TIMEOUT errors when loading PQ'S.
i can obviously try it without but do you know what the point of it is or is it literally that it just loads PQueries's quicker., thanks steve
if i could ask one further question of you,
what does the FAST DATA LOAD do on power query settings. i have always turned this ON. As i seem to get the TIMEOUT errors when loading PQ'S.
i can obviously try it without but do you know what the point of it is or is it literally that it just loads PQueries's quicker., thanks steve
With "Fast Data Load" Excel/Power Query allocates maximum of available resources (CPU, memory) to query downloading. During that other processes could be unresponsive. Yes, it accelerates data loading but decelerates if not stops for a while other processes.