Forum Discussion
Solved
Excel get data from web is only loading one table from the web page and not any of the others.
So basically as the title says, I am trying to import data into excel from a web page (https://www.baseball-reference.com/leagues/majors/2023-standard-batting.shtml this on to be exact) and I am runn...
Afraid that's nothing to do with that if only to parse HTML code. Power BI Desktop connector returns both tables and suggests transformation to generate some more
but second table is generated from HTML code. Such parser is built-in in above connector
Hope one day Power Query connector for web will be improved for Excel as well.
Recently same connector appeared in Beta version of Excel 365. Hope it'll be generally available in a while.