Forum Discussion
Using Web Service Connection in Excel and Power BI
I'm not able to work even a simple example mentioned here.
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,
3 Replies
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 Sourceyou 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
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?
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
