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