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

[Former Member]

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

[former_member186746]

Hi,

Did you check SAP notes for this behaviour? Also check the prerequisistes of this functionality, if the limit is not mentioned then create an OSS message with SAP.

Kind regards, Rob Dielemans