Learn how to make API calls by using List.Generate in Power Query. This video takes you through what an API is, how to create series with List.Generate and how to shoot requests to the API until the database is empty.

WRITTEN BLOGPOST
https://gorilla.bi'>https://gorilla.bi/powerquery/listg...

Master Functions and Syntax in M
https://powerquery.how

ABOUT BI GORILLA
BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills.

SUPPORT MY CHANNEL
Any videos are made free of charge. You can support my channel by giving a donation through: https://paypal.me/rickmaurinus.

Website: https://gorilla.bi'>https://gorilla.bi

SUBSCRIBE TO MY CHANNEL
https://youtube.com/bigorilla?sub_con...

LET'S CONNECT
Blog: https://gorilla.bi'>https://gorilla.bi
Facebook:   / bigorilla  
Twitter:   / rickmaurinus  
LinkedIn:   / rickmaurinus  

Thank you for your support!

CHAPTERS
00:00 Introduction
00:35 Explaining the PokeAPI
02:37 From Web for API Call
05:44 Create API Function
07:11 Understanding List.Generate
09:02 List.Generate with Record
11:50 Add API Function to List.Generate
15:39 Condition for Do While logic

MUSIC
Killing Time Kevin MacLeod (incompetech.com)
Licensed under Creative Commons: By Attribution 3.0 License
http://creativecommons.org/licenses/b...

#api #listgenerate #powerquery