I need to crawl data from SQL Server Database. For this, I created an external list using Business Connectivity Services. However, I encountered a limit on the number of requested rows: my table contains more than 2000 rows.

  • How can I get around this problem?
  • Is it possible to make the data requested by parts?
  • Is there another better way to index data from the database?


I found that the limit on the number of returned rows does not affect the search crawler, it is able to successfully index all records from external content regardless of limits.

  • you can increase the throttle limits. Nov 2, 2017 at 6:24

1 Answer 1


Have a look here

Increasing throttle limits would degrade the query performance.

As advice, try to design your BDC models with different finders according to your business requirements and use them on your target external list over dedicated views. (Eg. Refine by quarter, Filter by the current user, ...)


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.