Forum Discussion
Using Web Service Connection in Excel and Power BI
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-page I was able toc onn...
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