I have worked on something similar previously where I had to add Page Number to the worksheet in order to display (say 50 rows per page) with ability to go to next pages via a slider or entering page number manually. I have followed Jonathan Drummey's - paginating dashboard v2.twbx
Refer to this page for additional info: Re: Paging View on the Dasboard
If this help's, then mark it correct so others can benefit from it. Thank you.