Can I increase BI Publisher output to CSV beyond the maximum setting of 2 million records?

The default maximum number of rows for CSV output from BI Publisher is 1,000,000, although if required, you can download up to 2,000,000 rows to a spreadsheet. Downloading more than 2,000,000 rows, however, can lead to degradation of services and potential issues with BI Publisher reporting capabilities. BI Publisher is meant for creating documents. If you require to extract larger numbers of records, consider using Oracle Business Intelligence Cloud Connector (BICC).

For more information on configuring your BI Publisher settings, see the topic How do I optimize BI Publisher settings to reduce issues with runtime memory and data export?