Forum Discussion
Solved
Power query for pagination
I am directly connecting to a data source using an API. I am trying to overcome to 1k record limitation. I am wondering if there is a better way to implement pagination than what I am currently doing...
I found a blog online that shows me how to do it but thank you!
Hi rachaelwalker ,
I found some articles which might be helpful to solve your issue:
How To Do Pagination In Power Query
Iterate Over Dynamic Web API Pages With Power Query – How To Resolve Cursor-Based Pagination
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for the resources! I created a query following their instructions but receiving the following error
Expression.Error: We cannot apply field access to the type List.
Details:
Value=[List]
[email protected]
This is my m code. Any ideas?
I found a blog online that shows me how to do it but thank you!