One key limitation is the Run Report restriction, which limits data extraction to the first 2,000 rows of a report.
For more details on this limitation, we recommend reaching out to Salesforce support.
Additionally, you can explore the following resources for more information:
Increase number of records can be exported from Salesforce Reports API