Forum Discussion
Calling multiple SOAP calls
Just curious if you ever found out a solution here - I have to go through a similar sequence to grab data from a soap API. Each of the steps works individually, but the sequencing is out of order and it's making multiple calls at one step.
I did, but it's "ugly" (i.e. outside of Power Query/Fabric). We use a logic app to do the heavy lifting of making all the calls to the SOAP API and then Power BI just calls the Logic app.
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 IdeaThat would be really cool! Voted for the idea.