You can also refresh a connected table automatically, on a weekly, daily, or hourly basis. The scheduled time is based on the app's timezone settings, which are set in App properties.
To set or change refresh options:
Open your connected table and select Settings.
Click the Connection, for example, QuickBooks connection.
On the Details tab, locate Refresh options and then click Edit options.
Set or adjust the refresh options and then click Done. To stop a connected table from refreshing according to a schedule, select Manual only.
Tip: Before you change the refresh options, make sure you understand the purpose of the connected table.