Bold BI Release History - 8.1
8.1.41
New Features
AI
- Introducing the Conversational AI Assistant in Bold BI® Designer and Viewer, which empowers you to effortlessly interact with your data and dashboards using simple, natural language. With just a few words, you can create complex visuals like multi series stacked bar charts, line charts, grids, and more. Easily customize widget properties like colors, fonts, and other settings simply by asking the AI Assistant.
Bold Data Hub
- Added support for Oracle, Snowflake, and Google BigQuery as destination data warehouses. Users can now seamlessly integrate these data warehouses as datastores in Bold Data Hub.
Server
- Provided support to configure IP whitelisting, enhancing the security of Bold BI sites.
- Introduced Subcategory Support, enabling more efficient organization and management of your dashboards.
- #526649 – Added functionality to view application activities performed by users in both the Server and UMS in on-premise deployments.
Designer
- Provided support for the dynamic language translator.
Embedding
- JavaScript Embedding – Provided an API to enable the AI assistant feature in both the viewer and designer.
Improvements
AI
- Improved Q&A widget with improved stability in multiple filters and multiple series widget generation.
Data Sources
- Improved the performance of the REST data source workflow by initially transferring 10 pages of records, with the remaining data transferred during refresh.
- Provided support for pagination and dashboard parameters in the API to export raw data from the data source.
- Customized the default data source loading experience in the preview designer for large data sources.
- Provided Dashboard parameter and Custom Attribute support to SSAS connector.
- #562711 – Provided Incremental refresh support to Twilio data source.
- #515667, #574418 – Provided support to include current value in relative date filter.
Designer
- Provided Support for Grouped AND/OR Conditions in URL filter.
Embedding
- Enhanced iframe embedding to provide navigation support between designer and viewer, facilitating smoother collaboration.
- Added support for JavaScript embedding to obtain height and width from the element or its parent element and made the height and width API as optional.
- Added types support for dashboard options in typescript.
- Improved the performance of rendering multiple widgets in JavaScript embedding.
Bold Data Hub
- Provided support to Yaml and Amazon DynamoDB connector in Bold Data Hub.
Server
- Included an option to enable the performance metrics and query metrics dashboard.
- Added support for data alert creation within the existing schedule API.
- Changed the “Merge Data Source” to “Append Data Source” and relocated this under “New Data Source”.
Bug Fixes
Server
- Fixed the issue where the applied filter was not displayed on the views dashboard.
- Fixed the CORS settings issue when updating from the REST API.
- #610804 – Resolved the issue with the “get system setting” API not functioning correctly when inheriting settings from UMS.
- #600951 – Fixed the extra margin issue in the dashboard designer iframe embedding when resizing the browser.
- #627131 – Fixed the issue where the schedule would not run if the user who created it left the site.
IDP
- #623011 – Fixed the issue where the UseSiteIdentifier node value was not updating correctly when changes were made from the Docker environment variable.
- Fixed the issue where the “no records to display” message appeared on the homepage upon refresh.
Embedding
- Fixed a console error in the JavaScript embedding that occurred when switching dashboards prior to the initial dashboard fully rendering.
Designer
- Fixed the dashboard upload failure problem when same connection exists in the database.
- Modified the info content for “Enable Page Wise Exporting” option in PDF export dialog.
- Fixed the issue where the saved data alert schedule did not open in the UI when using the Data Alert API validation.
- Fixed the Redis connection timeout issue when accessed by 3,000 users.
- Fixed the sub-category design issues in the publish dialog.
- #614309 – Fixed the sorting does not apply issue when pivot grid is configured with Year in rows and columns.
- #617136 – Fixed the pivot foreground and background not working properly issue when conditional formatting is applied.
- #611630 – Fixed the Grid KPI Column Data showing 100% instead of 0% issue when actual and target value is zero (0).
- #625067 – Fixed the filters not working issue when custom view data is configured.
- #615460, #544713 – Handled the error in the query mode of the dashboard parameter when the connection is not configurable.
- #616354 – Fixed the widget removal issue in server when removing widget from embed application.
- #611380 – Fixed the filtering is not working issue when Null/Blank replaced values are filtered through text filter and Allow filtering option in Grid widget.
- #619709 – Fixed the issue where the applied filter was not displayed on the views dashboard.
- #625504 – Resolved the data source duplication issue that occurred while uploading the dashboard.
- #633439 – Fixed the issue where the Map widget was not rendering with data cache when using Marker customization.
- #634321 – Fixed the issue where filter data was not maintained in the view’s underlying data with the custom option.
- #631888 – Fixed the issue where it was not possible to edit the column name properly in view data customization.
Data Sources
- Resolved the object reference issue when adding the expression in an invalid query in code view mode.
- Resolved the encryption issue when publishing the data source to another site.
- Resolved the issue with the data source initial filters not retaining the include and exclude values.
- Resolved the issue with viewing underlying data when using the custom attribute in the SSAS connector.
- Resolved the issue where the initial filters were not properly maintaining the ‘Exclude’ and ‘Include’ values in the data filter.
- Restricted the Append Data Source icon from being enabled for appended data sources.
- Resolved the issue related to custom attribute errors in live mode connections for the PostgreSQL data source.
- Fixed the issue where dashboard parameter date-type fields appeared blank in table mode.
- Resolved the “Object reference not set” issue in the template dashboard with the dashboard parameter.
- Resolved the issue where the Google AdSense connector was not connected.
- Resolved the object reference issue when searching for an unavailable data source and importing the existing sample data source.
- Resolved the issue of being unable to upload in both Live and Extract modes for the Google BigQuery dashboard.
- Resolved an object reference issue when configuring the refresh setting and switching between Extract and Live connections.
- Resolved the issue where a new data source could not be created and was instead being appended to an existing data source.
- Resolved the issue where the ‘OK’ button was not working for the IN and NOT IN number data filters in the Oracle data source.
- Resolved the object reference issue in all extract data sources after deleting the code view with the query filter.
- Resolved the object reference issue when removing a data source name and saving it in Edit Connection.
- Resolved the issue where the query filter was not maintained in the datasource when using the boolean data type.
- Resolved the issue where the ‘Refresh Failed’ message was empty when a folder or file name was renamed or deleted in SharePoint.
- Fixed the issue where OAuth accounts could not be deleted.
- Resolved the issue where the card widget displayed an incorrect count in MYSQL IMDB.
- Resolved an object reference issue when executing the query without dragging and dropping the table in code view mode.
- Resolved the issue in the dashboard where the total percentage expression used in a filter caused an error.
- Resolved the issue where the data type was automatically changed when clicking ‘Change Column Type’ instead of selecting a specific data type.
- #637333 – Resolved the issue where the data source was breaking when updating the column using the REST API.
- #626638 – Resolved the issue where the widget was not displaying all the data in oracle connector.
- #631206 – Resolved the issue where the relative filter returned an empty result to the grid with the POP widget.
- #635182 – Fixed the filter issue that caused unchecked null and other values to appear in charts.
- #634535 – Resolved the issue with reconnecting the data source in MySQL.
- #635213 – Fixed the issue where the query execution message was not properly visible on the query designer page in Dark mode.
- #628953 – Fixed the issue preventing the MSSQL data source from being saved.
- #634060 – Fixed the issue with the period-over-period filter not functioning in the Google BigQuery dashboard.
- #631406 – Fixed the issue where the dynamic connection using a dashboard parameter was not working for the MongoDB connection.
- #631572 – Resolved the issue where year filtering did not work in Google BigQuery.
- #630259 – Resolved the issue where the data filter condition in the data source reverted from “AND” to “OR” even after saving the data source.
- #617606 – Hidden the “Run” button for extract mode data sources.
- #624267 – Resolved the issue where the expression value was not retrieving data properly in the Elasticsearch data source.
- #626451 – Resolved object reference issue and implemented the API for adding multiple columns while rendering the dashboard and data source.
- #623732 – Resolved the issue where getQueryResult was called instead of retrying query execution in Google BigQuery.
- #625946 – Resolved the issue where the date filter was not working in the Google BigQuery dashboard.
- #628643 – Resolved the issue where adding a new expression broke the existing expression when changing the time zone and date language in the site settings.
- #626985 – Resolved the issue where an incorrect date was shown in the date filter when modifying the language and time zone settings on the site.
- #624272 – Resolved the issue where sorting was not working in the pie chart legend when using the Elasticsearch data source.
- #624270 – Resolved the issue where all data was displayed after enabling virtual scrolling with paging in Elasticsearch.
- #625479 – Resolved the issue where Oracle double-type values were not updated in the preview data on the query designer page.
- #625351 – Fixed the issue where columns starting with ‘__’ were not extracted in MongoDB.
- #623732 – Resolved the random object reference issue when using a multiple inner join query in the Google BigQuery connector.
- #622396 – Fixed the issue where user-based filters were not working properly when the user-based filter data source was not included in the dashboard.
- #624698 – Fixed the issue encountered when copying a dashboard with the ‘Copy the data source’ option enabled on a site with a MySQL connection.
- #614522 – Restricted the upload of dashboards in extract mode if the IMDBs are different.
- #624270 – Fixed the issue where the count was not showing when applying pagination for the Elasticsearch data source.
- #615256 – Resolved the issue where the Number card count was not displaying correctly in PostgreSQL.
- #618092 – Resolved the issue where the Grid with Period-over-Period widget was not functioning with ClickHouse.
- #586192 – Displayed an alert popup when saving the data source with invalid columns in expressions.
- #586192 – Resolved the issue of retaining the same name and data type while editing the extract data source.
- #599305 – Fixed the issues related to adding new columns in the live data source table.
- #586192 – 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.
- #621948 – Resolved the issue where the same schema could not be maintained when reconnecting to the same URL in the REST data source
- #615475 – Resolved the issue where the AppFolio data source failed to use next_page_url to handle rate limits.
- #618529 – Resolved the issue where ‘Capitalize Each Word’ threw an ‘Index Outside Bounds of Array’ error.
- #617241 – 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.
- #617166 – Restricted the use of the array_agg() expression while creating the expression.
- #579583 – Displayed the correct custom attribute name instead of ‘Server Not Reachable’ when the custom attribute is not available.
- #617104 – Fixed the issue where column values were either too long or too short when uploading an Excel sheet.
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
- 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.
Note : The bug or feature items that do not have a corresponding ID associated with them are internally identified.