Power Query - can I make my query working faster?

hi,

is it possible to make the final stage of my Query ("Final") work faster? No it takes 10 minuts minimum.

Please find the file attached. It is just a part, because the orginal takes data from separate file, but I do not think this is a probelm in this case. please have a look

Hey afgi,

In Power Query if you wrap your source around the "Table.Buffer" command it might improve speed. Read about it at:
https://docs.microsoft.com/en-us/pow...m/table-buffer and
https://www.myonlinetraininghub.com/...in-power-query


BTW - no file was attached. I assume it was too big.

[QUOTE=MarvinP;5294275]Hey afgi,

In Power Query if you wrap your source around the "Table.Buffer" command it might improve speed. Read about it at:
https://docs.microsoft.com/en-us/pow...m/table-buffer and
https://www.myonlinetraininghub.com/...in-power-query

hi,

thanks, but I have done it. pls find the file attached in first post