Performance Metrics and Limitations of Excel and CSV Export
By exporting dashboards or widgets in Bold BI, valuable insights generated from your data become easily accessible, shareable, and usable in various contexts. Exporting to formats like Excel or CSV allows for further manipulation and analysis of the data. Below are the performance metrics and limitations of Excel and CSV format exporting.
Performance Metrics of Excel and CSV Export
The performance metrics are collected based on exporting a Grid widget with raw data. The Grid widget is configured with 15 columns, and the CSV or Excel file downloading speed will depend on the user’s network speed.
Excel Export
| Data Size | Export Request Completion Time |
|---|---|
| 5 lakh Records | 3.2 min |
| 1 million Records | 5.0 min |
CSV Export
| Data Size | Export Request Completion Time |
|---|---|
| 5 lakhs Records | 1.0 min |
| 1 million Records | 2.7 min |
| 2 million Records | 9.2 min |
Limitations of Excel and CSV Export
In the Bold BI application, there are default limits set for exporting data to Excel and CSV formats. By default, the Excel export is limited to 150,000 rows, and the CSV export is limited to 2,000,000 rows. These limits can be adjusted by an administrator through the configuration settings. Follow the steps below to modify the Excel and CSV export rows limit:
- Access the UMS
Settingspage using the link{domain}/ums/administration. Replace{domain}with your actual domain name.
- Select
Configurationfrom settings and chooseconfig.jsonfrom the dropdown.
- In the
config.jsonfile locate theExcelMaxRowLimitproperty and enter the desired row limit for Excel exports and locate theCSVMaxRowLimitproperty and enter the desired row limit for CSV exports.
- To apply the changes, restart the Bold BI application using the IIS Manager.
- Refer to the article Understanding Row Limitations in Exporting data for Excel export limitations imposed by Excel itself.
- When exporting data to CSV format, there are no row limitations. This means any size of data can be exported to a CSV file without worrying about hitting a row limit. This makes CSV a good option for exporting large datasets.
- Exporting large amounts of data to CSV will have a performance impact.
Additional References
- Exporting Widget to Excel
- Exporting Widgets to CSV
- Understanding Row Limitations in Exporting Data in Bold BI
By understanding these performance metrics and limitations, you can make informed decisions on the best export format for your data needs in Bold BI.
