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...
thanks for the reply sergei, i wil look into the table.join function.
concerning table.buffer though, do i insert that code at the start of my join query (above), so
= Table.NestedJoin.Buffer(Class, {"Column2"}, myid, {"Trnid"}, "myid", JoinKind.LeftOuter).
instead of
= Table.NestedJoin(Class, {"Column2"}, myid, {"Trnid"}, "myid", JoinKind.LeftOuter).
how would i enter the code? Or does it not work for nested.join queries.
thanks for your help, best, steve
concerning table.buffer though, do i insert that code at the start of my join query (above), so
= Table.NestedJoin.Buffer(Class, {"Column2"}, myid, {"Trnid"}, "myid", JoinKind.LeftOuter).
instead of
= Table.NestedJoin(Class, {"Column2"}, myid, {"Trnid"}, "myid", JoinKind.LeftOuter).
how would i enter the code? Or does it not work for nested.join queries.
thanks for your help, best, steve
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.
- Hi Sergei Baklan,
I have a query where I am doing 10 joins, Could you please help me how to use table .Buffer and NestedJoin in that case - Please help? ThanksSorry, I didn't catch what is you problem exactly. To make joining more reliable you may use Table.AddKeys() to declare primary keys for each of joined table.
- 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 steveWith "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.
