Forum Discussion
import from web show html table ?
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
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
3 Replies
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
Jimmylet 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
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
