How to Refresh Data Source Created with Stored Procedures

When working with stored procedures, it’s important to note that temporary tables will not be updated automatically when the data source is refreshed. This is due to the workflow of the system. However, there is a way to manually refresh the stored procedures to ensure that the data is up-to-date.

Steps to Refresh Stored Procedures

1. Edit the Data Source: The first step is to edit the data source.and re-run the stored procedure.
   

   

2. View Updated Data: After re-running the stored procedure, you should be able to see the updated data.
   

   

3. View Widgets with Updated Values: Finally, you can view the widgets with the updated values. This ensures that the data is current and accurate.
   

   
   
   By following these steps, you can ensure that your stored procedures are always up-to-date, even when working with temporary tables.

Note: In Bold BI, the data sources that support stored procedures include:

1. Microsoft SQL Server
2. Oracle
3. MySQL
4. Azure Synapse Analytics
5. MariaDB
6. SingleStore