Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Foreach loop in PowerQuery

Hi, Maybe a stupid question but I'm kinda new to PowerQuery and was looking for something similar to a foreach.    Basically what I'm trying to do is perform an API call and from results in the fi...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • PhilipTreacy's avatar
    PhilipTreacy
    6 years ago

    Hi Anonymous 

     

    I've got a blog post that deals with just this situation but I don't know the rules here for linking out to such things so I won't.

     

    Using a custom function may do the job but without knowing a lot more about what it is you are actually trying to achieve, it's very hard to give you a solution.

     

    What API are you using?

     

    What data does the 1st query return?

     

    How do the 2nd queries get affected by this?

     

    How do you want to change the URL in the 2nd query/ies.

     

    Regards

     

    Phil

v-yingjl's avatar
v-yingjl
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

Based on your description, you may want to pass parameters in the URL using power query. 

You can refer this simliar issue which introduces it in details that could help you to try:

https://community.powerbi.com/t5/Desktop/Passing-a-parameter-to-a-URL/td-p/103363

 

 

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.