Bold BI v8.1 Release Highlights for Embedded Analytics

Introduction

We are excited to announce the Bold BI^® v8.1 release, packed with enhancements to your embedded BI experience across Windows, Docker, Linux, Kubernetes, and Azure environments. This new release introduces significant product updates designed to streamline your user experience. To download the latest version of Bold BI, visit our account page or log in if you have existing account.

This blog will explore v8.1’s features, fixes, and improvements in detail.

Server enhancements

• We have provided support to configure IP whitelisting, enhancing the security of the Bold BI sites.
  

• We have added functionality to view application activities performed by users in both the Server and UMS in on-premise deployments.
  

• We have provided subcategory support to enable more efficient organization and management of your dashboards.
  

Server improvements

• We have included an option to enable the performance and query metrics in a dashboard.
• We have included support for data alert creation in an existing Schedule API.
• We have renamed Merge Data Source to Append Data Source and moved it under the New Data Sources category.
• We fixed the extra margin issue in the dashboard designer iframe embedding when resizing the browser.
• We resolved the issue with the Get System Setting API not functioning correctly when inheriting settings from UMS.
• We fixed the CORS settings issue when updating from the REST API.
• We fixed the issue of a duplicate Session Timeout dialog appearing when using the same pager preview form in the custom UI.

Designer enhancements

• We have provided support for a dynamic language translator.
  

Designer improvements

• We have provided support for grouped AND/OR conditions in the URL filter.
• We have fixed the dashboard upload failure problem when same connection exists in the database.
• We have modified the info content for ‘Enable Page Wise Exporting’ option in PDF export dialog.
• We have fixed the issue where the saved data alert schedule did not open in the UI when using the Data Alert API validation.
• We have fixed the Redis connection timeout issue when accessed by 3,000 users.
• We have fixed the sub-category design issues in the publish dialog.
• We have fixed the sorting does not apply issue when pivot grid is configured with Year in rows and columns.
• We have fixed the pivot foreground and background not working properly issue when conditional formatting is applied.
• We have fixed the Grid KPI Column Data showing 100% instead of 0% issue when actual and target value is zero (0).
• We have fixed the filters not working issue when custom view data is configured.
• We have resolved the error in the query mode of the dashboard parameter when the connection is not configurable.
• We have fixed the widget removal issue in server when removing widget from embed application.
• We have fixed the filtering is not working issue when Null/Blank replaced values are filtered through text filter and Allow filtering option in Grid widget.
• We have fixed the issue where the applied filter was not displayed on the view’s dashboard.
• We have resolved the data source duplication issue that occurred while uploading the dashboard.
• We have fixed the issue where the map widget was not rendering with data cache when using Marker customization.
• We have fixed the issue where filter data was not maintained in the view’s underlying data with the custom option.
• We have fixed the issue where it was not possible to edit the column name properly in view data customization.

AI enhancements

• We have introduced a new Conversational AI Assistant in Bold BI Designer and Viewer to enable intuitive, natural language interaction with dashboards and data.

AI improvements

• We have enhanced the Q&A widget with improved stability in multiple filters and series for widget generation.

Embedding enhancements

• JavaScript Embedding – Provided an API to enable the AI assistant feature in both the viewer and designer.

Embedded BI improvements

• We have provided support to navigate seamlessly between the viewer page and the designer page in the iframe embedding, facilitating smoother collaboration.
  

• We have added support for JavaScript embedding to retrieve the height and width from either the element itself or its parent element, and we have made the height and width API optional.Obtaining height and width from the element in JavaScript embedding

• We have added the types support for the dashboard options in the typescript.
• We have improved the performance of rendering multiple widgets in the JavaScript embedding.
  

• We fixed a console error in the JS embedding that occurred when switching dashboards before the initial dashboard had fully rendered.

Bold data hub enhancement

• We have provided support to use oracle, snowflake, and google bigquery data warehouses as the datastores in the Bold Data Hub.
  

Bold data hub improvements

• We have provided support to YAML and Amazon DynamoDB connectors in the Bold Data Hub.
  

Data sources improvements

• We have improved the performance of the REST data source workflow by initially transferring 10 pages of records, with the remaining data transferred during refresh.
  

• We have provided support for the pagination and dashboard parameters in the API to export raw data from the data sources.
  

• We have customized the default data source loading experience in the preview designer for large data sources.
• We have provided dashboard parameter and custom attribute support to the SSAS connector.
  

• We have provided incremental refresh support to the Twilio data source.
  

• We have provided support to include the current value in the relative date filter.
  

• We have resolved the object reference issue when adding the expression in an invalid query in code view mode.
• We have resolved the encryption issue when publishing the data source to another site.
• We have resolved the issue with the data source initial filters not retaining the include and exclude values.
• We have resolved the issue with viewing underlying data when using the custom attribute in the SSAS connector.
• We have resolved the issue where the initial filters were not properly maintaining the “Exclude” and “Include” values in the data filter.
• We restricted the Append Data Source icon from being enabled for appended data sources.
• We have resolved the issue related to custom attribute errors in live mode connections for the PostgreSQL data source.
• We have fixed the issue where dashboard parameter date-type fields appeared blank in table mode.
• We have resolved the “Object reference” not set issue in the template dashboard with the dashboard parameter.
• We have resolved the issue where the Google AdSense connector was not connected.
• We have resolved the object reference issue when searching for an unavailable data source and importing the existing sample data source.
• We have resolved the issue of being unable to upload in both Live and Extract modes for the Google BigQuery dashboard.
• We have resolved an object reference issue when configuring the refresh setting and switching between Extract and Live connections.
• We have resolved the issue where a new data source could not be created and was instead being appended to an existing data source.
• We have resolved the issue where the “OK” tab was not working for the IN and NOT IN number data filters in the Oracle data source.
• We have resolved the object reference issue in all extract data sources after deleting the code view with the query filter.
• We have resolved the object reference issue when removing a data source name and saving it in Edit Connection.
• We have resolved the issue where the query filter was not maintained in the datasource when using the Boolean data type.
• We have resolved the issue where the ‘Refresh Failed’ message was empty when a folder or file name was renamed or deleted in SharePoint.
• We have fixed the issue where OAuth accounts could not be deleted.
• We have resolved the issue where the card widget displayed an incorrect count in MYSQL IMDB.
• We have resolved an object reference issue when executing the query without dragging and dropping the table in code view mode.
• We have resolved the issue in the dashboard where the total percentage expression used in a filter caused an error.
• We have resolved the issue where the data type was automatically changed when clicking “Change Column Type” instead of selecting a specific data type.
• We have resolved the issue where the data source was breaking when updating the column using the REST API.
• We have resolved the issue where the widget was not displaying all the data in oracle connector.
• We have resolved the issue where the relative filter returned an empty result to the grid with the POP widget.
• We have fixed the filter issue that caused unchecked null and other values to appear in charts.
• We have resolved the issue with reconnecting the data source in MySQL.
• We have fixed the issue where the query execution message was not properly visible on the query designer page in Dark mode.
• We have fixed the issue preventing the MSSQL data source from being saved.
• We have fixed the issue with the period-over-period filter not functioning in the Google BigQuery dashboard.
• We have fixed the issue where the dynamic connection using a dashboard parameter was not working for the MongoDB connection.
• We have resolved the issue where year filtering did not work in Google BigQuery.
• We have resolved the issue where the data filter condition in the data source reverted from “AND” to “OR” even after saving the data source.
• We have hidden the “Run” button for extract mode data sources.
• We have resolved the issue where the expression value was not retrieving data properly in the Elasticsearch data source.
• We have resolved object reference issue and implemented the API for adding multiple columns while rendering the dashboard and data source.
• We have resolved the issue where getQueryResult was called instead of retrying query execution in Google BigQuery.
• We have resolved the issue where the date filter was not working in the Google BigQuery dashboard.
• We have resolved the issue where adding a new expression broke the existing expression when changing the time zone and date language in the site settings.
• We have resolved the issue where an incorrect date was shown in the date filter when modifying the language and time zone settings on the site.
• We have resolved the issue where sorting was not working in the pie chart legend when using the Elasticsearch data source.
• We have resolved the issue where all data was displayed after enabling virtual scrolling with paging in Elasticsearch.
• We have resolved the issue where Oracle double-type values were not updated in the preview data on the query designer page.
• We have fixed the issue where columns starting with ‘__’ were not extracted in MongoDB.
• We have resolved the random object reference issue when using a multiple inner join query in the Google BigQuery connector.
• We have fixed the issue where user-based filters were not working properly when the user-based filter data source was not included in the dashboard.
• We have fixed the issue encountered when copying a dashboard with the “Copy the data source” option enabled on a site with a MySQL connection.
• We have restricted the upload of dashboards in extract mode if the IMDBs are different.
• We have fixed the issue where the count was not showing when applying pagination for the Elasticsearch data source.
• We have resolved the issue where the Number card count was not displaying correctly in PostgreSQL.
• We have resolved the issue where the Grid with Period-over-Period widget was not functioning with ClickHouse.
• We have displayed an alert popup when saving the data source with invalid columns in expressions.
• We have resolved the issue of retaining the same name and data type while editing the extract data source.
• We have fixed the issues related to adding new columns in the live data source table.
• We have restricted the expression deletion process when the Play button is clicked and displayed an alert popup if there are any changes in the name or data type.
• We have resolved the issue where the same schema could not be maintained when reconnecting to the same URL in the REST data source
• We have resolved the issue where the AppFolio data source failed to use next_page_url to handle rate limits.
• We have resolved the issue where “Capitalize Each Word threw an Index Outside Bounds” of Array error.
• We have resolved the issue where the custom attribute was not functioning in the MySQL data source when transferring the dashboard to another site using a different database.
• We have restricted the use of the array_agg() expression while creating the expression.
• We have displayed the correct custom attribute name instead of “Server Not Reachable” when the custom attribute is not available.
• We have fixed the issue where column values were either too long or too short when uploading an Excel sheet.

ID improvements

• We have resolved the issue where the no records to display message appeared on the home page after a refresh.
• We have corrected the problem with the UseSiteIdentifier node value not updating correctly when changes were made through the Docker environment variable.

Breaking changes

• The Q&A widget no longer requires manual fine-tuning or configuration. The necessary model is now hosted in a cloud environment, and your Bold BI service will connect to the model via API to generate the widgets.

Important note

• Now, you need to use the updated embed JS version, hosted in https://cdn.boldbi.com/embedded-sdk/v8.1.41/boldbi-embed.js.
• We have enhanced the performance of loading multiple widgets in the javascript embedding. Please note that support will work and take effect if the embed SDK Wrapper and Bold BI Server are on the same version effectively from v8.1.41.
• To enhance the clarity and scope of our platform, we have officially renamed Bold ETL to Bold Data Hub.

Conclusion

The latest features, fixes, and enhancements for Bold BI^® v8.1 will enhance your ability to create more intuitive and visually stunning dashboards. With improved performance, advanced data visualization options, and enhanced user collaboration tools, this release is set to elevate the data analytics experience to new heights. For more information about this new release, please feel free to check our release page.

If you need assistance or have any questions regarding our product updates, please feel free to contact us via the Bold BI website. You can log in to submit your question, if you have an existing account. If you’re not yet a customer, get started with Bold BI now by signing up for a free trial!