Issue with Fabric GraphQL pagination

I have an issue with Fabric GraphQL's pagination that I hope someone in here can help me solve.

I would like to use GraphQL to pull data from a set of Lakehouse tables. I have to use pagination to loop over multiple pages, because some tables have a number of rows higher than 100.000, which is the maximum that can be specified using the first() operator.

I have tried using a combination of endCursor and next, but this always returns a null result. I suspect that it is because the endCursor always places itself after the last record.

I've tried searching around the forums, but without luck. I can neither find anyone with the same issue, nor anyone who has successfully set up pagination with GraphQL.

Is anyone in here able to help?