# Refresh Your Data Extracts Every 5 Minutes In this data-driven world, every business relies heavily on data to make decisions for the future. We should update such data and refresh in visualization tools at equal intervals to allow for effective decision-making. The data refresh feature of Bold BI enables your dashboard data to refresh automatically. Most business users track real-time key performance indicators (KPIs) through mobile devices or large TV screens. This lets them quickly react to changes in key metrics and take corrective action when issues arise. Bold BI also lets you schedule refreshes for the whole dashboard or specific widgets at regular intervals. In this blog post, we are going to explore the following topics: * [**Configuring refresh setting for a dashboard**](https://www.boldbi.com/blog/refresh-your-data-extracts-every-5-minutes/#configuring-refresh-setting-for-a-dashboard). * [**Configuring refresh setting to data source.**](https://www.boldbi.com/blog/refresh-your-data-extracts-every-5-minutes/#configuring-refresh-setting-to-data-source) * [**Scheduling data refresh from SQL data source.**](https://www.boldbi.com/blog/refresh-your-data-extracts-every-5-minutes/#scheduling-data-refresh-from-sql-data-source) * [**Refreshing data from local files.**](https://www.boldbi.com/blog/refresh-your-data-extracts-every-5-minutes/#refreshing-data-from-local-files) We’ll also see in a supply chain example how visualizations can be updated at regular intervals when data is changing frequently. ## Configuring refresh setting for a dashboard To enable auto refresh for a dashboard, open the dashboard in edit mode and click the **refresh icon** in the toolbar highlighted in the following image. ![Dashboard designer toolbar](https://cdn.boldbi.com/wp/blogs/refresh-your-data/toolbar-v1.webp align="left") **Dashboard designer toolbar** The **Refresh Settings** dialog opens. ![Refresh Settings dialog](https://cdn.boldbi.com/wp/blogs/refresh-your-data/refresh-settings-dialog-v1.webp align="left") Select **Enable Auto refresh** and set the [**timer**](https://help.boldbi.com/working-with-dashboards/preview-dashboard/refresh-dashboard/#how-to-set-the-timer-for-automatic-refresh) in the Time Interval box. From now on, the dashboard will retrieve data automatically at the specified interval period. To enable automatic refresh for particular [**widgets**](https://help.boldbi.com/working-with-dashboards/preview-dashboard/refresh-dashboard/#how-to-enable-automatic-refresh-for-particular-widgets-in-a-dashboard) in a dashboard, you can select the widgets you want to refresh from the list in the Refresh Settings window. When you enable refresh for specific widgets, the data will be updated only for those widgets. Also, you can restrict automatic refresh to happen only for record insertion or deletion in the [**associated database**](https://help.boldbi.com/working-with-dashboards/preview-dashboard/refresh-dashboard/#how-to-enable-automatic-refresh-only-for-any-record-insertion-or-deletion-in-the-associated-database) instead of data changes. ## Configuring refresh setting to data source Bold BI has an internal data store for processing data from files and web data connections. This data processing mode is called extract mode. All NoSQL databases, files, and REST API connections work in extract mode, where the data is extracted and moved into the data store. You can configure refresh settings to periodically update data in the intermediate data store from the actual source. ```plaintext The data store is configurable with SQL Server and PostgreSQL databases in Bold BI Enterprise Edition. ``` You can configure refresh settings for a data source through any of the following ways: * [**Scheduling refresh from the data sources listing page.**](https://www.boldbi.com/blog/refresh-your-data-extracts-every-5-minutes/#scheduling-refresh-from-the-data-sources-listing-page) * [**Scheduling refresh from data source designer page.**](https://www.boldbi.com/blog/refresh-your-data-extracts-every-5-minutes/#scheduling-refresh-from-data-source-designer-page) * [**Scheduling refresh from New Data Source window.**](https://www.boldbi.com/blog/refresh-your-data-extracts-every-5-minutes/#scheduling-refresh-from-new-data-source-window) ```plaintext Only data sources created in extract mode will have the refresh settings options. ``` ### Scheduling refresh from the data sources listing page To configure refresh settings in the data sources listing page, choose a data source that you want to refresh. Click the options button for that data source and select **Refresh Settings** in the drop-down list. Now the Refresh Settings window opens where you can schedule the refresh. ![Data sources listing page](https://cdn.boldbi.com/wp/blogs/refresh-your-data/data-listing-page-v1.webp align="left") ### Scheduling refresh from data source designer page To configure refresh settings from the data source designer page, click the **Refresh Settings** button in the tool bar, as shown in the following image. ![Data source editing page](https://cdn.boldbi.com/wp/blogs/refresh-your-data/data-source-v1.webp align="left") This opens the **Refresh Settings** window. ### Scheduling refresh from New Data Source window Let’s see how to configure refresh settings for a Web API data connection. Click the **Refresh Settings** button in the Web API data source configuration window. ![Web API connection window](https://cdn.boldbi.com/wp/blogs/refresh-your-data/web-api-connection-v1.webp align="left") In the **Refresh Settings** window, select the refresh type, recurrence, start date, and end dates. ![Refresh settings window](https://cdn.boldbi.com/wp/blogs/refresh-your-data/refresh-settings-window-v1.webp align="left") You can schedule the data refresh to occur hourly, daily, weekly, or monthly. The application time zone is displayed below the date picker. The start time of the schedule is converted to the client time zone and shown on the right side for your convenience. After configuration is completed, click **Schedule**. From now onwards, data updates in the intermediate data store at the specified time interval to help you keep your dashboard updated with the latest data. Let’s see how to schedule a data refresh from a SQL Server database in extract mode. ## Scheduling data refresh from SQL data source You can schedule incremental refreshes for any SQL-type data sources. To do so, connect the SQL data source in extract mode and choose the column with the time stamp as shown in the following image. ![Incremental Refresh Settings window](https://cdn.boldbi.com/wp/blogs/refresh-your-data/incremental-refresh-settings-v1.webp align="left") The intermediate data store refreshes with latest data when modified or when new rows are identified in the source. In extract mode with non-SQL data sources, during every refresh time interval, the selected tables will be dropped, and all the data will be pulled (full refresh) from the database and moved into the data store. When connected to your SQL data source in live mode, the dashboard always shows the latest data whenever you open or refresh the dashboard manually. To refresh the dashboard, click the **Refresh** option in view mode as shown in the following image. ![Supply chain performance dashboard refreshed manually](https://cdn.boldbi.com/wp/blogs/refresh-your-data/supply-chain-performance-v1.webp align="left") Let’s see how to refresh data from local files or local storage. ## Refreshing data from local files To refresh data from local files, edit the data source, and from the data source designer, click **Edit Connection** to choose the file \[Excel, CSV, JSON, etc.\] that holds updated data. ![Data source editing window](https://cdn.boldbi.com/wp/blogs/refresh-your-data/data-source-editing-v1.webp align="left") Now, let’s look at an example of refreshing dashboards in a [**supply chain department**](https://www.boldbi.com/resources/dashboard-examples/supply-chain/) to get an idea of how to schedule refreshes. ![Warehouse management dashboard](https://cdn.boldbi.com/wp/blogs/refresh-your-data/warehouse-management-v1.webp align="left") The [**Warehouse Management dashboard**](https://www.boldbi.com/resources/dashboard-examples/supply-chain/warehouse-management-dashboard/) assists in inventory management by analyzing inventory metrics, such as the movement of goods and the cost factors involved, to process transactions like shipping, picking, putting away, and receiving. Further, it tracks important KPIs such as inventory carrying costs, return rate, backorder rate, stock details in selected warehouses, and so on. Using this dashboard, you can track product availability as the number of units that are in the warehouse compared to the number of units that have been ordered. In this dashboard, data is fetched from the database in extract mode, and incremental refreshes are scheduled based on the **Date** column to move the latest data into the data store. The refresh time interval is set to refresh the dashboard on a daily basis. After the schedule runs and an incremental refresh occurs, the date column will be pulled from database and records with the latest date values will be updated in the dashboard. The **Product Stock Details** widget showcases this. Refer to the following images to get a better idea about the scheduled data refresh in this example. ![Before refresh schedule runs](https://cdn.boldbi.com/wp/blogs/refresh-your-data/before-refresh-schedule-v1.webp align="left") ![After refresh schedule runs](https://cdn.boldbi.com/wp/blogs/refresh-your-data/after-refresh-schedule-v1.webp align="left") ## Conclusion Thus schedule the data refreshes as needed in Bold BI® dashboards and their associated data sources. If you have any questions on this blog, please feel free to post them in the following comment section. Get started with Bold BI by signing up for a [**free trial**](https://www.boldbi.com/pricing/) and create more interactive business intelligence dashboards. You can also contact us by submitting your questions through the [**Bold BI website**](https://www.boldbi.com/contact/) or, if you already have an account, you can [**log in**](https://www.boldbi.com/account/) to submit your support question.