Forum Discussion
Apply any changes in/from Power Query Editor takes hours.
When I either want to make or apply any changes in/from Power Query Editor, it takes hours, and the loading screen shows an unreasonable amount of data usage (see pictures of 4GB & 9,9GB). I can't c...
I am not sure which is faster.
Buffer your lists before the above step:
Buff_LP_EUR = List.Buffer(#"5 ValidLP_EUR"[LP_EUR])
Buff_Material = List.Buffer(#"5 ValidLP_EUR"[Material])
or this might suffice:
Table.AddColumn(#"Add brugerdefineret4", "ListPriceLookup", (outer) => Table.SelectRows(#"5 ValidLP_EUR", each [LP_EUR] = outer[Material])[Price]{0})