import from web show html table ?

[utgqw]

i have problem when i import from web like...

https://www.internetworldstats.com/stats3.htm

https://en.wikipedia.org/wiki/UEFA_Champions_League

when connect done it show "html table" that is split many many table in selection tab ???

it should be real URL there (see picture on the right) the selection is easy for pick

but i dont know some another powerbi desktop show like this (left side of picture )

thank you 

[utgqw]

let me explain @Jimmy801 

in PowerQuery > Get data > web > paste url like  in Fromweb (basic)

i do this in 3 computer

1 laptop computer show in right picture (real url in red circle right picture) it have only 3 table

it normally OK 

but when i do it in another

2 laptop computer show in left picture (html table) it split data in 20table 

i hard find the real table what i want

i dont know what going on 

[Jimmy801]

Hello @utgqw 

be aware that when you choose Web in Excel and Power BI that they are using two different functions... Web.BrowserContent is not available in Excel - at least in older version. So if you need that the are showing the same, go for Web.Contents and Web.Page

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

[Jimmy801 · Accepted solution]

Hello @utgqw 

I don't get the point here. I think there are used two different functions. Web.Page(Web.Contents) and Web.BrowserContent(Html.table). But anyway, the result should be the same. Or what exactly is your issue where you are blocked?

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy