Customizing the Export Data Limit for Excel and CSV

By default, the export limits for Excel and CSV files are set to ensure optimal performance. Excel exports are limited to 100,000 rows, while CSV exports can accommodate up to 2 million rows. However, these limits can be customized to better suit specific needs.

Steps to Customize the Export Limit

1. Access Configuration Settings: Navigate to the following URL: http://{your_domain}/ums/administration/config-editor
   This will direct you to the configuration settings page of the UMS.

2. Select the Configuration File: In the “Search your files” drop-down menu, select the config.json file.

3. Modify Excel Export Limit: Locate the ExcelMaxRowLimit key within the file. Set the desired value to adjust the export limit for Excel.

4. Modify CSV Export Limit: Locate the CSVMaxRowLimit key within the file. Set the desired value to adjust the export limit for CSV.

5. Save Changes: Ensure that you save the changes made to the configuration file.
   

   

6. Restart the Application: For the changes to take effect, restart the application.

Additional References

• Export Options in Bold BI
• Export limitations in Excel and CSV