Timeout Settings for Web API Data Retrieval in Bold BI

When connecting to a Web API data source in Bold BI, the default timeout interval for retrieving data is set to 4 minutes. This is the maximum duration Bold BI will wait for a response from the Web API before the request is considered to have timed out.

After the data is successfully retrieved from the Web API, it is extracted and stored in the data store database. Subsequently, data for widget visualizations is fetched from this data store database, rather than directly from the Web API. The query timeout for fetching this data for widgets is 5 minutes. This means that the data for the widget must be returned within this timeframe to be displayed; otherwise, the query will time out.

These timeout settings are in place to ensure that dashboards remain responsive and that long-running queries do not hinder the user experience. Timeouts may be triggered if the widget query is processing large amounts of data, causing delays in the database execution of these queries. In cases where timeouts occur frequently, it may be necessary to follow the below suggestions:

1. Optimize the Web API (network latency, response size, etc.)
2. Apply filters at the Web API level, such as using query parameters to narrow down the data by date or other criteria.
3. Configure Data Filters in Bold BI to filter the data