Power Query - Looping and API Calls!

preview_player
Показать описание
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

API Link

Mquery Link
  1. BA Sensei
Рекомендации по теме
Easy Looping in 0:15:46

Easy Looping in Power BI/Power Query

Power Query - 0:09:55

Power Query - Looping and API Calls!

List.Generate() Function and 0:23:56

List.Generate() Function and Looping in PowerQuery

List.Generate in Power 0:22:56

List.Generate in Power Query - Tutorial with Easy Examples

Como fazer Loopings 0:26:27

Como fazer Loopings no Power Query?

Simple List.Generate in 0:09:49

Simple List.Generate in Power Query: Master the 'Do Until Loop' Easily

The Magic of 0:14:27

The Magic of Working with Lists in Power Query

each & underscore_ 0:09:58

each & underscore_ in Power Query Explained

IIT Roorkee PYQs 1:25:25

IIT Roorkee PYQs | Control Systems Previous Year Questions - Part 1 | GATE 2025 EE/EC/IN #gate2025

List Accumulate Power 0:07:31

List Accumulate Power Query Looping through Records

Excel Power Query 0:45:19

Excel Power Query - Split and Loop text in a cell using Function. NO VBA | XL Studio | #xlstudio

Power BI (Desktop) 0:05:07

Power BI (Desktop) - Loop no Power Query: lógica FOR com List.Accumulate

Dynamic Column Calculations 0:16:55

Dynamic Column Calculations in Power Query | 4 Crazy Solutions

Pagination and DO/WHILE 0:14:13

Pagination and DO/WHILE in Power BI / Power Query

How to Use 0:18:27

How to Use List Generate to Make API calls in Power Query

Why is my 0:08:09

Why is my Power BI refresh so SLOW?!? 3 Bottlenecks for refresh performance

VLOOKUP in Power 0:10:39

VLOOKUP in Power Query Using List Functions

Criando Loop (Recursividade) 0:09:16

Criando Loop (Recursividade) no Power Query

Scrape Glassdoor using 0:10:34

Scrape Glassdoor using LOOP Functions in Power Query // Beginners Guide to Power BI in 2020

How to create 0:23:41

How to create Loops in Power Query/Power BI CA Satish Panchal| Advance Editor | List.Accumulate

Excel Weekend 7 0:23:07

Excel Weekend 7 - Loop no Power Query efetuando consulta na web - Joviano Silveira

Eigene Funktionen in 0:03:28

Eigene Funktionen in Power Query erstellen | #DurchblickDurchDaten

Use Power BI 0:25:25

Use Power BI to loop through multiple pages of an API

Power Query: How 0:07:41

Power Query: How to mass replace values based on a list | Excel Off The Grid

Комментарии
Автор

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

neils
Автор

Loop in PQ is awesome. Thanks for knowledge sharing.

KhajonsakLun
Автор

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"

franp
Автор

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?

ItsWithinYou
Автор

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!.

andyelgohary