cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
panchag Frequent Visitor
Frequent Visitor

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-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,

2018-11-09_12-16-17.png

3 REPLIES 3
Community Support Team
Community Support Team

Re: Using Web Service Connection in Excel and Power BI

Hi @panchag

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

4.png

 

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 

5.png

 

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

you could get the table expand

6.png

 

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 Frequent Visitor
Frequent Visitor

Re: Using Web Service Connection in Excel and Power BI

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?

Community Support Team
Community Support Team

Re: Using Web Service Connection in Excel and Power BI

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

7.png

 

Best Regards

Maggie

 

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 46 members 1,097 guests
Please welcome our newest community members: