Increase the time out on a SOAP query

[Anonymous]

Hey, guys,

I have a problem regarding the refresh of tables, which are obtained by a SOAP query. I have the tables, but most of the times they are not updated and returns an error message "The operation has timed out". I tried to write [Timeout=#duration(0, 0, 5, 0)] in the WebContent, but I got another error "3 arguments were passed to function which expects between 1 and 2". How do I increase the time out? Below you can see the query, which is not working.

Source = Xml.Tables(
    Web.Contents(senior_soap_xml_source_link,
        [Content=Text.ToBinary(
          "<soapenv:Envelope xmlns:soapenv=""http://schemas.xmlsoap.org/soap/envelope/"" xmlns:ser=" & senior_link & "><soapenv:Header/>

            <soapenv:Body>
              <ser:table_1>
                <user>" & senior_user & "</user>
                <password>" & senior_password  & "</password>
                <encryption></encryption>
                <parameters><!--Optional:--><flowInstanceID>?</flowInstanceID><!--Optional:--><flowName>?</flowName></parameters>
              </ser:table_1>
            </soapenv:Body>

          </soapenv:Envelope>"),
          Headers=[#"Accept-Encoding"="gzip,deflate", #"Content-Type"="text/xml;charset=UTF-8"]], [Timeout=#duration(0, 0, 15, 0)])
    )

[v-juanli-msft]

Hi @Anonymous 

I'd recommed you to use XML Driver to create SQL Queries to call SOAP API in Power BI, please refer to this blog: https://zappysys.com/blog/call-soap-api-power-bi-read-xml-web-service-data/

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@v-juanli-msft , thank you for the reply!

Why use an XML Driver? It's possible to write the SOAP Query directly in Power BI, as I did. The request was working perfectly since February. In this month I have been facing this time out problems, I really change nothing.

Regards,

Guilherme.