Forum Discussion
Passing Page values in Header in web data source and pagination
Hello Community, I am trying to do two things here: 1. Increase the number of records in the first call to the api. default set in our application is 50. Max rows returned in one call can be 200...
Not quite sure about what you've actually tried already, but using the Query-record should give you the chance to fill in your parameters: https://www.thebiccountant.com/2018/03/22/web-scraping-2-scrape-multiple-pages-power-bi-power-query/
Hi sgoel,
As I know, there is no page_info setting in HTTP header, so I think you need to pass this in URL parameter or in M query.
I find some similar post for this problem, you could try to refer to this post and Iterating over an unknown number of pages in Power Query for details.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.