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