Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 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
    5 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

Chad_OB's avatar
Chad_OB
Frequent Visitor
5 years ago

Hi Anonymous 

 

I'm curious to know if you had any issues after publishing to the Power BI Service.

 

I have a similar solution to yours which refreshes successfully in Power BI Desktop, but not in the Power BI Service. If its the latter, then what did you do to solve this?

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Chad_OB, For me it worked perfectly after I built a connector.