Forum Discussion
Understanding why Table.Buffer makes a difference in dependency chain
This thread contains a lot of information around how Table.Buffer works: https://social.technet.microsoft.com/Forums/en-US/34e454b5-3a18-4eef-b920-40703c93f390/tablebuffer-for-cashing-intermediate-query-results-or-how-workaround-unnecessary-queries-issue?forum=powerquery
Wow, that's quite some thread ImkeF ! I'll read through it several times today, and try to comprehend it all :-)
Wow....putting Table.Buffer around any steps that referenced previous queries reduced my load time from potentially hours to one and a half minutes. (I say potentially hours, because I'd never dared to load all 30k rows of data for both Tables at once, nor attempted to make as many as 7 recursive steps. Even just loading one tenth of the data for 5 steps was taking a good 10 minutes or more).
I take it that I want to buffer each input just once, as soon as it appears in the current query that is referencing previous ones?