Easy Looping in Power BI/Power Query

In this Power BI tutorial, we learn how to iterate over data in Power Query! This is an advanced technique that allows you to loop through function calls to produce the desired result. This specific technique creates a While or Do While loop, and you can also create a For loop if desired.

Link to PBIX:

---------------------------------------------------------------------------------------------------------

To enroll in my introductory or advanced Power BI courses:

Elite Power BI Consulting:

Data Insights Tools:

Connect with me on Twitter!

[MrAszpic]

This is the sort of content people love to learn in Power Query. Power Query is mostly magic and recipies for most of the folks, who only use the most basic stuff because it's what most tutorials and guides teach. Thanks for the vid, keep it going!

[GusGuitarPD]

Oh man, I am actually dancing right now! The 3rd example was exactly what I was looking for to get all results from a API. Thank you SO MUCH!

[LincolnOliver]

I have been looking for this a lot of weeks. THANK YOU VERY MUCH!!! You got a new fan!!!

[JustinKemp]

This is amazing. I learned a few different things in one video, thank you for sharing!

[Ryan-zzhh]

Excellent video!! Can't wait to binge watch the rest of your channel!

[Capitalist]

Thank you for this video. I had only thought to use List.Generate to create loops. This is much cleaner and easier to understand approach. Thanks for sharing.

[KNP-BI]

Thank you, this is gold.
And now that I've got the whole "relative path" working with the Web.Contents in my Dataflow I have a working solution.

[AdiCristea]

Awesome work as usual, Parker, thank you!

[hieulaivu]

I love you bro. You don't know how valuable this tutorial means to me. Keep up the good work bro

[AnandDwivedi]

best explanation. I could not explain so systematically in my classes.

[erikbohn]

OMG! Mind blown! Thank you, this will be so useful.

[darrenvinales]

Thanks very much, this has already helped me.

[HachiAdachi]

🤯 @ call! Who knew! (I didn't). Awesome!! Thank you, Parker!

[alanfoley]

Hi Parker - thanks for sharing - Just came across this - Excellent and extremely useful piece of M code - how could you tweak this so it does not require any manual input (currently you need to Input 0 as a parameter to the function) - I have a requirement where I need to implement looping "nextpage" something similar to this in a batch process - obviously a called interactive function won't work - how would you handle the "RelativePath - if loop =0" part internally - care to share a solution? much appreciated - a small mod I had to make was that in my case the 'nextpage' variable was not there on the last page so this worked for me "token = try Source[nextpage] else null" - thanks Alan

[adithyanamada]

Hi I have one quick question, can I use "Measure" inside the advanced query editor if yes can you please let me know how.

[chiquita]

Do these codes work in PowerPivot? I know not all PowerBI functions work in PowerPivot but looking for how to do looping in PowerPivot's Dax. Generateseries doesn't seem to work

[sarahkaufman]

Hello! I am trying to implement similar code but getting an error saying a cyclic reference was encountered during evaluation. Any ideas what might be causing this?

[tvj]

I have a list of urls (csv files) which a service returns to me and I need to download all those files from cloud storage. Is the approach shown in the video memory efficient?

[jorgechoypernia]

Thanks for the tutorial... It was really useful... Would you be able to show how can this work for API that have a combination of PATH parameters and QUERY parameters in the URL? For example, ... Thanks

[ioanniskiokpas]

Greetings! Any insight on how we can loop with DAX? Say for an Exponential Moving Average?