How to use Browser Time Zone Feature in Bold BI

The browser time zone feature in Bold BI allows you to convert datetime columns in your SQL data sources from UTC to the desired time zone, which is the end user’s browser time zone.

Understanding the Time Zone Feature

Consider the following table in the database with a datetime column:

If the time zone feature is not enabled in Bold BI, it will display the records in UTC format, regardless of the browser time zone.

If the browser time zone feature is enabled, it will display the data according to the end user’s time zone. For example, if the end user’s time zone is IST, the data will be displayed in IST.

Enabling the Time Zone Feature

By default, the browser time zone feature is turned off. To enable it, you need to set the following property to true in the appsettings.json file located at:

[Installation Drive]:\BoldServices\bi\dataservice\appsettings.json

"BrowserTimeZone": true

Once the browser time zone feature is enabled, datetime columns in your SQL data sources will be displayed according to the end user’s browser time zone.

Additional References

• Bold BI Documentation
• Convert timestamp column from one timezone to another