I have asked this question on another forum, but haven't received any response yet. So hopefully another set of eyes/brains will help.

I am a user of Table.Buffer in Power Query, as I do find some quicker results than letting it stay as written, wrapping the IN in the Buffer

Example:
Source = #"My Data"
in
Table.Buffer(Source) as table

The Source used in this Excel File/Power Query is set up dynamically, and allows for all of the source data to be linked correctly when the file is moved to another machine. However, the queries will not refresh on the other machines when I keep the Table.Buffer in my queries.

Is there a setting that needs to be changed somewhere or anything else that I may not be thinking of to allow for this to work when sending off to others? Everything else works fine on the other machines after the Table.Buffer is removed.

Thoughts? Any help would be greatly appreciated.


Admins: I have tried provide the link to my cross-post, but it will not allow me to do so.