How to Resolve Image Caching Issues in BoldBI Dashboards

When using BoldBI dashboards, you may encounter an issue where an image, set up using a URL as the source, does not refresh correctly even though it has the same refresh settings as a data dashboard. This is due to BoldBI caching the image. This article provides two solutions to resolve this issue.

Solution 1: Using a Parameterized URL

Consider the URL https://imageurl/image.jpg?1234222 where https://imageurl/image.jpg remains constant and 1234222 is the changing part. You can create a separate column for the changing value in your database. If you already have one, follow these steps:

1. Configure the column into an image.
   
   
2. Create a parameterized URL where {0} is replaced with the column value. This way, when the dashboard refreshes, the column value gets updated and the image updates accordingly.
   

Solution 2: Using a Base64 Column

Another solution is to store the image as a base64 column in the database. Bind the column into the image field and configure the parameterized URL. This will ensure that the image updates correctly when the dashboard refreshes.

References

• BoldBI Documentation
• Understanding URL Parameters
• Base64 Encoding