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:
Go to:https://curbal.com/donwload-center
Click on community downloads and
Get download number 67.

World bank api: https://datahelpdesk.worldbank.org/kn...

List.Numbers: https://docs.microsoft.com/en-us/powe...


Here you can download all the pbix files: https://curbal.com/donwload-center

SUBSCRIBE to learn more about Power and Excel BI!
   / @curbalen  

Our PLAYLISTS:
- Join our DAX Fridays! Series: https://goo.gl/FtUWUX
- Power BI dashboards for beginners: https://goo.gl/9YzyDP
- Power BI Tips & Tricks: https://goo.gl/H6kUbP
- Power Bi and Google Analytics: https://goo.gl/ZNsY8l

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
https://curbal.com/courses-overview

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:
Website: http://www.curbal.com
Contact us: http://www.curbal.com/contact

▼▼▼▼▼▼▼▼▼▼

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:

https://curbal.com/product/sponsor-me

Many thanks in advance!

▲▲▲▲▲▲▲▲▲▲


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





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


QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► https://goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► https://goo.gl/bME2sB

#CURBAL #SUBSCRIBE