What is Buffer Refresh Settings
This setting represents : How long do you want to query the old data in the buffer instead of getting new data from the source ?
You connect to an Excel file.
The data is first copied in the buffer.
If you don’t set up Buffer Refresh Settings, it will never be updated.
If you set up “Refresh Every 1 Week”, it will not be update for 1 Week.
Then, the next time someone makes a query to this Connection, new data is copied in the Buffer.
Where to set up
Each Connection has its own refresh settings.
You can change the refresh duration by default at the Connection creation (or edition).
Just edit the Connection, and set up “Buffer Refresh Settings” as Enabled, and a duration to “Refresh Every”.