External list only showing 100 rows RRS feed

  • Question

  • I've created an External Content Type (ECT) and successfully connected via Secure Store to a BCS SQL database. After creating the basic READ operations for the "Read List" and "Read Item" in SPD I am only showing the top 100 rows. Why?

    This external list has 35K rows. I originally created a limit of 100 rows on the list, but have since removed that rule in SPD. My BCS throttle settings are set at 5000 records. Why can't I pull more rows of data? I am at a complete loss :(

    Please help.

    Thursday, February 14, 2013 8:43 PM