If I recall correctly this is what the data grid does if source is set to database. It retrieves the amount of records which need to be shown according to the maximum amount setting in the grid. If you click on the next button in the pagination, a new call to the database is done to retrieve the next set of records according to this threshold.
yes, agree. but in our case, the data source is a microflow that calls REST service to get the data. so I want to get and load the first 10 branches and on click to next, it should get the next 10 and so on.