Each search source has a maximum number of results that can be pulled into a table, and your limit of 25,000 may be exceeding system constraints. Additionally, tables in Clay are capped at 50,000 rows total, which includes all rows regardless of their status.