Reply
Frequent Visitor
Posts: 2
Registered: ‎03-18-2017

Get data from web: table is null

Hi,

 

I'd like to get data from websites where data is already under the "table" form, but it happens quite frequently that Power BI couldn't convert them to table. Do you have any idea how to get around this issue ?

Error.jpg

 

There's a website that just a day ago, I was able to extract perfectly a dozen tables. But this morning, I could no longer import data; I get the same issue as the screenshot above.

 

 

Moderator
Posts: 2,534
Registered: ‎03-10-2016

Re: Get data from web: table is null

Hi @zzzzoooo,

This is not a issue of Power BI Desktop, it is related to the design of your webpage.

As per this official article, Power BI Desktop can import data from tables on a web page. However, in your scenario, the data in the web page is not stored in a table. You can compare the elements of web page(http://en.wikipedia.org/wiki/UEFA_European_Football_Championship) introduced in official article and your web page(http://theahl.com/stats/standings).
1.PNG2.PNG


 

Thanks,
Lydia Zhang