How to connect to a SOAP API in Power BI/ Power Query

Learn how to connect to a SOAP API in power query!.

Link to service:

Join this channel membership to get access to all the recorded bites as they become available:

SUBSCRIBE to learn more about Power and Excel BI!

Our PLAYLISTS:

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Twitter ► @curbalen

#CURBAL #SUBSCRIBE

[flaviocarvalhokato]

God bless you. You saved me. Thank you very much!

[raf_martins]

Im so greatful! Really thank you. It help me a Lot.

[joanneosborne]

Amazing! Thanks, Ruth, I love all your training videos. ❤❤

[bjcomrie]

This was brilliant. Thanks for the effort.

[Sterh]

Very helpful video. You saved me a lot of time. Thank you.

[MilhouseBS]

SOAP :) What 90's madness is this? :) I did my share 10-20 years ago :)

[Silencioraul]

You are a genius !!! Thank you very much.

[vbonetti]

amazing video! so useful and the only source available on this topic that I found - thanks so much! Is there a follow up video to learn how to add a parameter in that code so that the value of the main variable can be set in an excel cell for example? ☺That would be so good! 😅

[alexsalex]

Hi, i really love your videos.

Is there a way to make soap get requests with sha256 encryption using a private key?

[danieltellesdemenezes]

Great video! It has helped me starting a Power Query (Excel) connection to a webservice. However, although the ws works with SOAP UI, I'm getting an error in Power Query. "The underlying connection was closed: unexpected error on a send." Any suggestions?

[pritichaudhari]

how to get Data from RESTful API which has "two Factor Authentication" e.g. Maconomy RESTful API framework.

[talihiggins]

I haven't seen that changing the " to #(0022) before. Is that a Power Query thing, or does it work in more languages? I know I've done things like changing a single quote to a double quote, etc, in Python before - could you have just changed it to a single quote? Very curious about this!

[amrutapatil]

I have tried by following what you have done but i have get internal error could please help me

[CraigEvans-gder]

Works great in Power Query, although I have just encountered a 400 error when the SOAP envelope calls for an Integer (Int) rather than a string value, or at least I think that is the problem because it is the only parameter that has changed

[arossi]

Thank you very much! My report in PowerBi works correctly with 3 soap data sources, however the data update only works locally with PowerBi desktop, when I publish the report I have not found a way to have an update via gateway when one wants as for the other reports, I can schedule it but it is not on request Is there a way to do it ? The correct behaviour shoul be the same of a report with direct query through gateway thanks

[AlexisKatopodis]

I tried to follow you to see the actual data (read method) of the call to the SOAP web service, but I saw only the column names. Do you believe that I can see them?

[ahv]

Hi,

I am getting data from an API that has two parameters like below in the URL:



These are the start and end dates of the report that I have manfully set up in the API URL. But, how do I make it dynamic so that everyday that I refresh the data in Power BI connect to the API and pull the latest data? My current M code is something like below:


let
Source = Json.Document(File.Contents("C:\Users\Ali\AppData\Local\Microsoft\Windows\INetCache\IE\EHD7MHFN\1120")),
#"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Column1" = to Table", "Column1", {"txtProvider",
"txtIncidentNo",
"FltDate",
"LogTime")

[lrvn]

It's possible do the same using a .svc SOAP webservice?

[bravucod]

What is a good resource to learn about apis with power query ?

[leemeiwah]

Hi Ruth, I've tried by following what u've done but I've a (500) Internal Server Error. I've tried to download your pbix file but unable to find it. Pls help. Thks! 😅😅