cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
guilherme_silva Frequent Visitor
Frequent Visitor

Increase the time out on a SOAP query

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)])
    )

 

 

2 REPLIES 2
Community Support Team
Community Support Team

Re: Increase the time out on a SOAP query

Hi @guilherme_silva 

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.

guilherme_silva Frequent Visitor
Frequent Visitor

Re: Increase the time out on a SOAP query

@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.

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)