Using Web Service Connection in Excel and Power BI

[panchag]

I'm not able to work  even a simple example mentioned here.

https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-importing-and-analyzing-data-from-a-web-p...

I was able toc onnect to web service but  it does not show any results from that web page   except teh screen below.

Do we need to check any other security restrictions ? I'm able to view the page via browser,

[v-juanli-msft]

Hi @panchag

It is weird, i test on my site, it runs successfully as the link.

My power bi desktop version is 

Version: 2.63.3272.40262 64-bit (October 2018)

Do you connect to the web url with power bi or excel?

If it still trouble connecting to the web source as the link said, please try the following workaround.

in Edit Queries, create a blank query, open the Advanced editor, past the code in.

let
    Source = Web.Page(Web.Contents("https://en.wikipedia.org/wiki/UEFA_European_Championship"))
in
    Source

you will see 

click on the "Table" (yellow and bold character) of the third line(the "Results[edit]" line)

you could get the table expand

Here are two pbix

"Using Web Service Connection" use the way the link suggested

"web service2" use the way i metioned above

Best Regards

Maggie

[panchag]

Thanks Maggie. It looks like i have som Antivirus running and preventing the data 

By the way , were you able to work with any WSDL  URL?

[v-juanli-msft]

Hi @panchag

It seems you could access to data currently, right? if so, could you kindly mark this thread as a solution?

Regarding connecting with WSDL URL, it is another question, right?

According to this link, i can get the wsdl file from a webservice's url, then use the WSDL URL to get data, it also give me the data as below

Best Regards

Maggie