Buffer Refresh settings

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 ?

For example

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”.

*Note : don’t forget to set Buffer Refresh settings also for a SQL Connection if you intend to use it in a multi-Connection Data Source !