Avoid Caching in Bold BI Dashboard when using Stored Procedure for MS SQL
When using Bold BI with dynamic queries from MS SQL, you may encounter issues with caching the last results. This article will guide you on how to prevent this issue.
Understanding Internal Cache
In Internal Cache mode, Bold BI executes the stored procedure completely and moves the result into a temporary table. After that, Bold BI uses the created temporary table for every execution in the stored procedure’s data source.
For more information on Internal Cache, please refer to the Bold BI documentation.
Using Open Query
To prevent caching the last results, you can try using the “OpenQuery” option. In this OpenQuery mode, Bold BI executes the stored procedure queries on the specified linked server for every execution in the stored procedure data source.
Refer the prerequisites from here to access stored procedure from MS SQL server.
Note:
OpenQuery only supports the Microsoft SQL Server and Azure SQL Database (Managed Instance only). All other servers like Azure SQL Database, Azure SQL Data Warehouse (Azure Synapse Analytics), and Parallel Data Warehouse does not support this OpenQuery.
When working with large data sets in Bold BI, it is recommended to use Open Query mode for connecting to stored procedures. Ensure that the prerequisites are met and that your server is supported before configuring Open Query mode.
Related Articles:
