Forum Discussion
Calling multiple SOAP calls
I had a suspicion that's where this would lead. So far I've tried one query with all the steps in sequence, I've tried separate queries, and I've tried storing request outputs in buffered lists... no success so far. I saw some guy turning requests into custom functions and harcoding a time delay between them, but that feels too brittle for comfort. Thanks for the response!
No problem, I'll look in the ideas forum to see if there is anything there, but it would be nice if we could create atomic sections in power query, be able to say that "this section has to happen s a single unit and in this order". it would make these caall to web API's that require a stepped approach (e.g. Login, Request data, Fetch Data) call possible.
Here's the Idea: Microsoft Idea
That would be really cool! Voted for the idea.