Export to CSV - Maximum?

3601907

Summary

Export to CSV - Maximum?

Content

I need to export more than 1 million rows to CSV from a BIP report. I see the default file size for export to CSV in BIP is set at 1 million. Can I export like say 3 million records in CSV? I am trying to strike a balance between client's requirement for huge dataset and the ability of the system to handle / process the huge amount of data.

Hendrik Schmidt

Hi

found

"...With Microsoft Office Excel 2007 and 2003:  the limitation:Worksheet size 1,048,576 rows by 16,384 columns

...

Again reminding that these limitations are not from BI Publisher but from MS Excel.  ..."

regards

3601907

I hit that limit when I tried exporting about 2 million rows. CSV will

export the 1,048576 rows and truncate the rest. Does Excel have the same

limit as CSV? Also default row limit in BI Publisher shows as 1 million but

with a box that allows you to change that value. Not sure what value to

increase that limit to with minimum impact to performance.

On Tue, Feb 13, 2018 at 12:12 AM, community-admin <

3601907

Thank you. That helps.

On Tue, Feb 27, 2018 at 1:44 PM, community-admin <

YGUTTIKONDA

One suggestion is to try split it into multiple batches, based on some kind of ID .

Please be aware that you are using a reporting tool to create data dumps which is not suggested rather write some package that can extract the required data.

Hope this Helps !!

YGUTTIKONDA

Pl mark the thread correct / completed