Forum Discussion
Covid-19 Vaccination Effort How to use table.buffer PLEASE HELP
Community Championtable.buffer receives a table as a parameter so:
thebufferedTable = table.buffer(Source) should work. Place that after the "Source =" step.
You can then refer to thebufferedTable in the next step instead of Source.
It can sometimes be trial and error to use it though so be warned.
Good luck.
Also Merge can be slow in Power Query. You can test this by duplicating the query and running it without the Merge onwards
It looks like buffering the source won't help me because its a folder not a file. How do I get it to buffer each file in the folder, not the folder itself? Also I tried as you suggested, buffering a few different steps in the query (see below for an example) but when I did that the query would never finish refreshing (it loaded all the data, then just sat there doing nothing).
thebufferedTable = table.buffer(#"Invoke Custom Function2")