Easy Looping in Power BI/Power Query

[@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!

[@BIElite]

Thanks Ary! You can take Power Query so deep if you want to. Personally, I relied on the GUI for most of my transformations for far too long.

[@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!!!

[@hieulaivu9984]

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

[@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.

[@AnandDwivedi]

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

[@BIElite]

Thanks Anand!

[@JustinKemp1992]

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

[@BIElite]

So happy to hear, Justin!

[@Capitalist89]

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.

[@Ryan-zz6hh]

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

[@stigmundfreud]

Thank you for this and the example, I am trying to adapt this now to a rate limited API.

[@AdiCristea]

Awesome work as usual, Parker, thank you!

[@BIElite]

Thanks Adi!

[@HachiAdachi]

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

[@BIElite]

Right! The best kept secret.

[@erikbohn2771]

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

[@BIElite]

Right, I can think of a bunch of use cases for this! Thanks for watching.

[@darrenvinales419]

Thanks very much, this has already helped me.

[@chiquita683]

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

[@astatine0085]

Thanks, very helpful tutorial.

[@kozmaz87]

The first example is recursion to be quite precise.

[@adithyanamada8550]

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

[@kennethstephani692]

Great video!

[@BIElite]

Thank you Kenneth!

[@tvj585]

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?

[@sadyaz64]

usefull as always thank you

[@BIElite]

Thanks sadyaz!!

[@sarahkaufman4505]

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?

[@gustavoballesteros1560]

Great video,

[@keagankemp6275]

Wow mind blown. Thanks a mil

[@BIElite]

No problem, Keagan!

[@keagankemp6275]

@@BIElite I have one issue though I have a page with player stats I have the names but for each player they have a unique I’d that is generated randomly I guess, I would like to have the loop find this random number when I supply the name is this possible? I’m new to loops or is there some other way to get this?

[@marketgrunt]

Masterful. 👍

[@BIElite]

Thanks for watching!

[@ioanniskiokpas4603]

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

[@BIElite]

I’ve tried to think through this exact use case more times than I care to admit. I’m afraid it’s not possible… sorry!

[@ioanniskiokpas4603]

@@BIElite thank you for the response!

[@vishalpawashe9487]

Thanks!

[@tnsparks]

I love your videos, I have 1 remark though that I learned after using your function feature to bring in Microsoft Forms data. When I publish it to power BI app and want to schedule a refresh it wont let it happen. It says because its a dynamic data source it wont schedule refreshes :( I tried to find a work around using the functions but have not been successful yet in finding a way to schedule a refresh.

[@amarjitbhagat1207]

Hey, Did you find any solution for this issue?

[@GusGuitarPD]

I applied the exact same code but I'm getting an error when I try to invoke the function. "A cyclic reference was encountered during evaluation." How can I avoid that error?

[@alanfoley5900]

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

[@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, /api/v3/feature/{fid}/history/sessions/{type}?dateStart=&dateEnd= ... Thanks

[@isalys1867]

Thank you for the video :) I need help because I can't publish to web my power bi report. I don't have tenants settings in my admin portal. What can I do? I found that the solution is to create an admin for my domain name server but I don't own the DNS. So what can I do?

[@israry5623]

Maysa Abou Jamra you can join the group here and place your question, I am sure you will get the correct answer to your query as I find this group very helpful facebook.com/groups/powerbi/

[@macm7730]

Hi... Thanks for all the videos... One quick question here. Do you mind sharing your thoughts on which exam we should take for Power BI certification? what do you recommend? DA-100 or 70-778?

[@israry5623]

@Mac M I believe it is obvious mate, 70 778 is going to be retired in Jan21 and DA 100 already has been rolled out - You Should go for DA100

[@BIElite]

Agreed with Israr! The DA-100 exam is the one to take moving forward.

[@macm7730]

@@israry5623 Thanks!

[@macm7730]

@@BIElite Thanks

[@emmanuelkamara3138]

Hello sir, Just saw one of your KZbin videos and I decided to automatically subscribe. Can someone please help me with the following questions Q1. How can I calculate sales mix in power BI? I have 3 categories of products (they all have sub products). category1= 40 unit c2 =50 units c3 = 20 unit total sales= 110 . sales mix for category1= 40/110. How to do this in power bi? q2. so basically I sell products on credit ....the outstanding column shows how much the customer should pay for payment to be completed. The other column shows the number of days for the product to be disabled. anything less or equal to -30 is cash at risk...meaning that the product has been disabled for more than 30 days. I want to calculate the portfolio at risk in power Bi but I don't know how to do it. Portfolio at risk= outstanding balance of products that has

[@inaciogoes6317]

had returned me that error: Expression.Error: A cyclic reference was found during the evaluation. Details Reason = Expression.Error

[@solidoffortitude]

It's not looping. In programming it is called recursion. Love your tips anyway, recent subscriber.

[@BIElite]

I agree on the distinction, but for 95% of Power BI users it's the same thing. Thanks for the sub!

[@SaurabhAgrawal32]

1st comment and 2nd like with 4th view. ☺