Power Query - Looping and API Calls!

In this video i show you how to loop through a API Call in Power Query and get back some really nasty insults from the API.
#data #dataanalytics #api #powerquery #powerbi #powerbidesktop #excel
Links
File Link
github.com/jbotes/powerbiTuto...
API Link
evilinsult.com/generate_insul...
Mquery Link
learn.microsoft.com/en-us/pow...

[@KhajonsakLun]

Loop in PQ is awesome. Thanks for knowledge sharing.

[@neils9565]

This is absolutely brilliant - I've been looking for how to do this for the longest time.

[@juja2819]

This is a higher level of PQ! :)

[@franp209]

Grate video! was just what I was looking for in a personal proyect. I'm having a problem nad I wanted to see if you could point me out the error, it's really weird. I create a function of the same style in PBI desktop and it works grate, but when i take it to a data flow on the web i get this error " One or more tables reference to a dynamic data source"

[@andyelgohary13]

Will this loop works in Web Services, I am trying to figure out how to create a loop that works when I publish my reports!.

[@basensei8699]

yes it can totally work for webservices!

[@ItsWithinYou]

I need to connect to API. For connection, there are 2 parameters - client id and password. Once enter the values of these 2 parameters, we get a token to access the api. This token is valid for 60 minutes so if the report is going to refresh again after 60 mins, it has to run this process again and generate a new security token. After accessing api, I need to input values from a column (from an existing table in power bi report) and api will give me rate value (in integer format) for each of these values. I need to save these rate values in a new column in an existing power bi table. Can you please provide guideline on how to accomplish this?

[@den8423]

its possible in VBA