How to do Pagination on a REST API in Power Query (Part 1)

In today's video, I am going to show you how to implement pagination when the number of pages or records to be returned are known.

Chapters:
00:00 Intro
00:30 Not all APIs have the same structure
01:10 Get data from World Bank API
01:45 How pagination works on the API
02:30 Hardcode the number of pages
04:50 Dynamically feed the number of pages
06:06 Explain List.Numbers
08:20 Unknow number of records?
Done!

Here you can download the power bi file used in the video:
Click on community downloads and
Get download number 67.


SUBSCRIBE to learn more about Power and Excel BI!

Our PLAYLISTS:

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:

▼▼▼▼▼▼▼▼▼▼

If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:


Many thanks in advance!

▲▲▲▲▲▲▲▲▲▲


************





************


QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Twitter ► @curbalen, @ruthpozuelo

#CURBAL #SUBSCRIBE

[CurbalEN]

If you dont know the number of pages, use this method:

[DiegoTorres-lf]

Thank you Corbal. This worked wonderfully for an api call that has variable number of pages (10-100).

[HachiAdachi]

Voting for sooner Part 2! Thanks, Ruth!

[leonelcontreras-t]

excellent video, knowing how to get information from api is really a great help. This video deserves so much more likes.

[nelsoneng]

Wanted to drop a line and say thank you! Can't tell you how much help this was. Thank you again!

[EverythingPants]

I've been wondering how to do this for ages, this is amazing. I've implemented it today for a client and it's worked perfectly - Thanks!

[melissaclaassen]

Thank you so much! I just got dropped into the deep end of the reporting pool at work, and this was an exceptionally helpful video!

[markgoode]

Yes please Ruth. Would love to see that second video. Thanks for sharing :) Great practical topic

[CeliaAlvesSolveExcel]

Love this! Making everything dynamic is exciting!

[rkartau]

Hey Loved the video. Making it really easy to learn the stuff. I'd really love to get the second part of the video.
The thing is that my company is usking JIRA and their API does not use this page nr system as you are showing and the table i need to process has 1150 rows, but jira is limiting it to 50 outputs per request. So as a result I think there is tone of people (many jira users) who'd love to get this second part as much as I do.

[skalsolutions]

As always, a great video with good content! Waiting for the second video! :)

[antique-bsbb]

yes please - part 2 sounds v interesting

[impossibru]

I realize I'm a couple weeks late but I would love to see part 2!

[lordmarioh]

This video is a lifesaver! Thank you so much!!!

[nurulbasar]

great video,
currently trying to call all available invoice pages from Xero(accounting tool). can't wait for next part.

[fajnefajne]

This video is very luxurious. Thank you very much. :-)

[waldof]

I've had opportunity to do both this and another one where I don't know the amount of pages beforehand, but in both cases, my main issue is that it won't refresh in the service. I'd love a video on that if you have a solution. As always thank you for your amazing content!

[seandavies]

Thank you so much ! Exactly what I needed !

[prabhakaran]

Thank you so much, wonderful explanation !!

[windsurfreview]

I'm running into a problem with the limits on the number of API calls I can maken (400 max per 5 minutes). Do you have any advice how I could solve this? Is there a way to pause the API calls?

Thanks for all your videos Ruth. They helped numerous times already.