What is the latest limit on OTBI export for CSV & Excel.

Question

I was able to export 75k in excel & 500k  records in csv with OTBI. However, I keep on reading that excel has a limit of 25k & csv has 75k as a limit. Do we have a way to change these limits for our instance. Can someone pls help me with the hard limit for export for excel & CSV vo OTBI analysis.

mkucuk_tr · Answer

Report data size maximum limit is 2147483648 bytes.

Nathan CCC · Answer

Hi,

For "bulk" data export the recommended by Oracle approach is Business Intelligence Cloud Connector (BICC) (not analytics and reports in OTBI nor the SOAP/REST API)

Oracle Fusion Cloud Applications

Creating a Business Intelligence Cloud Extract

F92942-01 24B

https://docs.oracle.com/en/cloud/saas/applications-common/24b/biacc/index.html

Why? see

My Oracle Support https://support.oracle.com/

Oracle Applications Cloud: Data Export Best Practices (Doc ID 2615185.1)

Oracle Fusion Transactional Business Intelligence and BI Cloud Connector Performance Recommendations (Doc ID 2679006.1)

CCourty · Answer

I was just working with an OTBI report yesterday that returns over 2 million rows. I was able to export 50k in XLS and 250k in CSV. I think it is a limitation of Excel so it is unlikely that there is any way to change this. You would need to use BI Publisher to be able to export all of the rows.