0 Kudos

SOAP Call Issue XML Response 417 Expectation Failed

Status: New
by Ylreeb Frequent Visitor on ‎12-12-2018 02:04 AM

Dear Forum,

 

I receive an error when requesting an XML as dataset via SOAPCall (endpoint hosted locally) under Windows 10.

Same call executed with SOAP-UI or Python (requests/XMLResponse) on the same Windows 10 maschine responding no issues...

 

Error-Message:

DataSource.Error: Web.Contents failed to get contents from 'http://endpoint-URL/' (417): Expectation Failed
Details:
    DataSourceKind=Web
    DataSourcePath=http://endpoint-URL/
    Url=http://endpoint-URL/

 

Query:

let
    Source = Xml.Tables(Web.Contents("http://endpoint-URL:80",[Content=File.Contents("c:\env\Envelope.xml"),Headers=[#"Accept-Encoding"="gzip,deflate", #"Content-Type"="text/xml;charset=UTF-8"]])),
    #"Expanded Table" = Table.ExpandTableColumn(Source, "Table", {"Name", "Table"}, {"Table.Name", "Table.Table"}),

.......

 

The same query works when PBI-Desktop is running under Windows 7.

 

Any idea?

Comments
by Moderator v-qiuyu-msft
on ‎12-12-2018 09:41 PM

Hi @Ylreeb,

 

In Windows 10 machine, please click on Get Data -> Web data source, type URL http://endpoint-URL:80, check if you are able to connect to it successfully. 

 

Please ensure the same Power BI desktop version runs on Windows 10 and Windows 7 machine. 

 

Best Regards,
Qiuyun Yu 

by Ylreeb Frequent Visitor
on ‎12-13-2018 04:31 AM

On all maschines is the latest version (2.64.5285.741 64-bit (November 2018)) installed.

 

Regards,

Marcus

by Moderator v-qiuyu-msft
on ‎12-17-2018 12:18 AM

Hi @Ylreeb,

 

Have you used Web data source in Windows 10 machine Power BI desktop with URL http://endpoint-URL:80? Is the connection successful? 

 

Best Regards,
Qiuyun Yu 

Idea Statuses