Forum

Table.Buffer - Quer...
 
Notifications
Clear all

Table.Buffer - Queries won't Refresh on other computers

3 Posts
2 Users
0 Reactions
139 Views
(@jj0354)
Posts: 2
New Member
Topic starter
 

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/

https://www.excelforum.com/excel-general/1375855-power-query-table-buffer-use-on-other-machines.html#post5662192

 

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?

 
Posted : 29/04/2022 3:04 pm
Philip Treacy
(@philipt)
Posts: 1630
Member Admin
 

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

 
Posted : 29/04/2022 8:55 pm
(@jj0354)
Posts: 2
New Member
Topic starter
 

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.

 
Posted : 30/04/2022 11:00 am
Share: