How to schedule a report that requires more than 25k lines

Summary:

When I schedule a report I am finding that I only ever get a maximum of 25k lines. This is not sufficient for the reports that we run regularly

Content (required):

We are utilising OTBI to run scheduled reports that include sku data, process data etc. An example would be sending a list of all skus created in a period, say a month, with specific data required by a particular part of the business. We are finding that these reports are all being truncated to only 25k lines, both in Excel and in .csv. This means that there is no point in scheduling any report that may at any time return more than 25k lines.