Skip to Content
0
Former Member
Apr 30, 2018 at 06:45 PM

Is there a way past the 1,000,000 row limit for Excel data sources in WebI reports?

221 Views Last edit May 02, 2018 at 11:11 AM 2 rev

Excel 2016 allows for 1,048,576 rows per sheet, but when using this as a data source in Web Intelligence in SAP BI 4.2, I am hitting an apparent default row limit of 1,000,000 rows, thus losing 48,500 plus rows of needed data. Is there a way to get past this default row limit?

Help please,

Joe Burgess