Mendix recently added a feature for this: https://docs.mendix.com/howto/logic-business-rules/server-side-paging#5-adding-paging-support-to-the-microflow-data-source
Are you using Persistent entity to show the Data , if yes Load all data at once and use pagination widget with some Page Size. Same applies for the Non Persistent too .
You can refer https://appstore.home.mendix.com/link/app/105694/
Custom Pagination also possible with some Domain Modeling