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.