Expression Error while loading query from API Source

[Anonymous]

So while I am trying to follow a guide to pull my data from an API into a table I was folowing this guide to help me paginate: Power BI/Power Query: API Response Pagination Part 1 - Paginate by Item Count  I keep running acros the error in my screen shot. I am just starting out in Power Query but I can understand after fumblnig around a bit, but pagination for the API has been slightly dificult. 

I've used several different pagination methods, and I know I can fix part of this by chaning the expression pageRange = {1..30} but this is a living data set so I am trying to get it incremented on refresh. 

This is the result I am expecting:

 

This is the link to the api documentation: FreshcallerAPI. I don't have any problems pulling the actual data, just paginating it is proving elusive to me. Each time a find a new method to try I get halfway to it working but ultimately it does not function.

[mahoneypat · Accepted solution]

Please see this video for another way to pull in paginated API data.

Power BI - Tales From The Front - REST APIs - YouTube

Pat

[Anonymous]

Thank you, this helped me get the last piece of the puzzle I was missing. Using your method I did have to make an alteration to my Power BI privacy settings but it worked like a charm. This is going to save me so much time now that I can stop doing weekly CSV dumps.