Load more does not work correctly in a table that is tied to an external object made available via S

Load more does not work correctly in a table that is tied to an external object made available via SF connect. In my case, I have an external object that has 9 records but on the model, I have set to initially load 5 records. So after page load, the table had five records displayed and shows 5+.  After clicking “load more”, I see 5 records and the record count is 5.

For this specific case, if I set the model to initially load 10, then the table has 9 records displayed with a record count of 9 and no “load more” button.

Do you have a sort order set on on this model?  If that order is not granular enough to differentiate between records sometimes the salesforce standard controller gets confused.  Add Id as the final sort order item in your model.

Hopefully this will take care of things.  

Thanks that worked and solved the issue