Error when loading webdata using API

[hansvanhoeij]

I am trying to load data from a webbased CRM tool (PerfectView) into PowerBI. I can load data from the tool using SoapUI so the connection works.

But still I get the following error when loading:

  rror: Web.Contents with the Content option is only supported when connecting anonymously.

This is my query:

let
URL = "https://api.perfectview.nl/V1/perfectview.asmx",
Request = "<soapenv:Envelope xmlns:soapenv='http://schemas.xmlsoap.org/soap/envelope/' xmlns:api='https://Api.perfectview.nl'>
<soapenv:Header/>
<soapenv:Body>
<api:UsersGetActive>
<api:credentials>
<api:ApiKey>xxx</api:ApiKey>
<api:DatabaseId>xxx</api:DatabaseId>
<api:UserId>xxx</api:UserId>
</api:credentials>
</api:UsersGetActive>
</soapenv:Body>
</soapenv:Envelope>",
Options = [Content = Text.ToBinary(Request),Headers=[#"Accept-Encoding"="gzip,deflate", #"Content-Type"="text/xml;charset=UTF-8"]],
Source = Xml.Tables(Web.Contents(URL, Options))
in
Source

Can anyone help me with this?

Thanks,

Hans

[surfersamu]

Click on Data Source Settings. Select the link or source and click on Edit Permissions. Select Annonymous and click OK.