Bold BI v7.11 Release Highlights for Embedded Analytics

Introduction

We are excited to announce the release of Bold BI^® v7.11! This version is designed to operate across popular environments, including Windows, Docker, Linux, Kubernetes, and Azure, for widespread compatibility. To download the new version of Bold BI, visit our account page or log in if you have an account. Let’s take a closer look at these new improvements.

New Features

Designer

• Users can now apply a background color or an image as a background to widgets in dashboards.
  

Widget

• We have provided support for a button widget.
  

Improvements

Data sources

• We have provided support for enabling SQL Server Always Encrypted, which keeps client data secure even from employees managing the database it’s in.
  

• Users can now apply a filter value in data preview and design modes.
  

Designer

• We have provided support for customizing the columns displayed in view underlying data mode.
  

• We have provided support for performance metrics in the dashboard view mode.
  

Server

• We have provided support for filtering schedules based on the date field and sorting the last run field in the schedule.
  

• We have provided a rename support API for dashboards.

Embedding

• In the Designer, use an API member to enable or disable the Explore Sample DataSource option in SDK-based embedding.
• Also, in SDK-based embedding, users can employ the new updateDashboardTheme method, which updates without needing to reload the dashboard.

ID

• We have included the Bold ETL option in the custom_ui JSON file.

Bug Fixes

Embedding

• We display an appropriate error message when a user lacks permission to view the dashboard in iframe embedding.

Data sources

• We have resolved the issue with data source encryption and decryption by managing it from the dashboard to the data sources.
• We have resolved the issue where a custom attribute could not be utilized with the UPPER function in expressions.
• We have restricted time zone enabling for date columns.
• We have fixed the issue encountered when uploading the dashboard with Windows authentication.
• We now display expressions in a pop-up that were causing execution issues in code view mode within the data sources.
• We have resolved the issue where date-time columns with range filters were not functioning properly in the ClickHouse data source.
• We conducted a thorough review for grammatical errors across all data source dialogs and pages in Bold BI.
• We fixed an issue where the data sources loaded with the old connection while using an external API in the UI if the URL was unreachable.
• We addressed the data source refresh issue for cloud sites.
• We have fixed an issue where double-clicking the Play button would only retrieve new column fields in Table mode.
• We have corrected a missing fiscal year issue that was applied at the data-source level.
• We resolved an issue where the QuickBooks Sandbox’s initial authentication was not functioning properly in Bold BI.
• We fixed the issue where the query text was not being logged in the HAR file.
• We resolved the issue where the DayOfWeek functionality was not operational in the ClickHouse data connector.
• We have addressed the issue where data source columns were not displayed on the query designer page in the SAP HANA ODBC DSN.
• We have fixed the filter and intermittent reload issues in the ClickHouse data source.
• We have fixed the query designer resolution issue.
• We fixed an issue with appending shared tables when using drag and drop in the Append data source.
• We fixed the issue where YEAR and MONTHYEAR date formats were not functioning in the Google BigQuery data source.
• We resolved the error thrown when both a user filter and a relative date filter were applied to the same users.
• We have handled the retry option to prevent the refresh failures in the Appfolio when facing excessive requests.
• We have improved the error log for the download and upload features.
• We fixed the issues related to the dashboard parameters and appending data sources.
• We fixed the issue where editing an SQL connector with Windows authentication was not possible.
• We disabled the Google Analytics Connector due to deprecation.
• We resolved the issue where icons were not rendering properly in the box connector.
• We fixed the refresh logs that were not displaying correctly when encountering large file sizes in SharePoint.
• We resolved the issue with refreshing in Google Sheets when a self-join was used in the Google Drive data source.
• We have resolved the data type icon mismatch for Google Cloud live data sources.
• We display a proper error dialog title on the data source query designer pages.
• We have hidden the data filter icon issue when initially creating the data sources in code view mode.
• We disabled the STDEV and VAR expressions in the ClickHouse connector.

ID

• We have resolved the issue in adding additional parameters for existing database connections.
• We have resolved issues in creating configuration nodes in upgrade cases.
• We have resolved the internal server error caused by the upgrade script issue in the UMS home page.

Server

• Now, the global user attributes are not updated in the site-level user attributes list.

Designer

• We have resolved the widget configuration issue when using the relative date option with a data cache.
• We have resolved the issue where the correct preset value was not selected in the dashboard parameter date range picker.
• We have fixed the issue where leading zeros were missing in the Excel exports.
• We have fixed the problem of PDF export failing when using a specific localization language.
• We have fixed the issue where the hidden columns were exported in Excel even when the Include Hidden option was disabled.
• We have added a reset option for replacing null and blank values with a default value.
• We have fixed the issue with a # symbol being added to URLs when clicking Click Here during the data cache refresh.
• We fixed the addition of commas in the Excel cell formatting when the group separator was set to empty.
• We have resolved the export failure issue when the Month Year type was bound in the filter section.
• We have resolved the issue where the Know More link in the Excel export failure message was unresponsive when clicked.

Widgets

• We have added a value-label hiding option for the bar, stacked bar, 100% stacked bar, column, stacked column, and 100% stacked column charts.
• We have resolved the visibility issue of the expression column in the KPI grid configuration.
• We have fixed a UI glitch with the more options icon on the KPI card when hovering over the combine/tab widgets.
• We have corrected the text overflow wrapping issue in the range legend of charts.
• We have fixed the issue with value labels taking up too much space between the bar and the value in the bar chart widget.

Important Note

• You need to use the updated embed JS version, hosted in https://cdn.boldbi.com/embedded-sdk/v7.11.24/boldbi-embed.js.

Conclusion

In conclusion, the Bold BI^® v7.11 release enhances embedded analytics with powerful new features and an improved user experience, empowering businesses to make data-driven decisions more effectively. Explore these updates on our release page today and feel free to send us suggestions for future improvements.

If you need assistance or have any questions, please feel free to contact us via the Bold BI website. However, if you have an existing account, you can log in to submit your question. If you’re not yet a Bold BI customer, try it for yourself by signing up for a free trial.