I've posted this on other forums, but have yet to get a response of any kind:
https://www.mrexcel.com/board/threads/table-buffer-queries-wont-refresh-on-other-computers.1200782/
I set up a number of my Queries with Table.Buffer, wrapping it up at the very end
Example:
Source = MyDataSet
Step1 = (MyDataSet, Do whatever here)
in
Table.Buffer(Step1) as table
It works fine and as expected on my machine, but when co-workers need to cover for me and use the same template it doesn't work for them. Is there a setting that needs to be updated or should I be placing the Table.Buffer elsewhere in my queries?
Hi John,
I don't see why that wouldn't refresh on another PC. When you say it doesn't work for others, how so?
What is MyDataSet? Perhaps the issue is with that?
What are you intending to achieve by using Table.Buffer? I wouldn't use it as you have. The buffer functions are intended to hold an evaluated version of a table/list etc in memory for use in a query, so would usually be used within the transformation steps to guarantee an outcome of subsequent steps.
Regards
Phil
Thank you for your reply, Philip.
I'm not sure as there is no detail provided on what doesn't work, other than it doesn't. Super helpful. HA
In the very scaled down example, the MyDataSet in any and all of my queries are typically either CSV or XLSM files. However they are quite large.
In all honesty, I'm self taught through Google U, and looking for some refresh speed in using the Table.Buffer and stumbled upon it in multiple sources but they haven't been super descript on the How.