This issue occurs because of the option "Limit size of result set to" is set to 5000 by default.
To resolve this issue, increase the value of "Limit size of result set to" to 10000 by following the below steps:
- Login to the designer with administrator credentials.
- Click on File and Import the Universe. Once imported, click on File and then Parameters.
- In the Universe parameters window, click on controls tab and check the option "Limit size of result set to" and change the value to 10000 as shown in the below screenshot:
<Please see attached file for image>
- Click on OK and then click on File and then click on Export.
- Once export in the designer is completed, login to Infoview and run the report.
You should now able fetch more than 5000 rows.