Excel get data from web is only loading one table from the web page and not any of the others.

[Collin__]

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 running into an issue where the import data from web function is allowing me to pull in the first table (Team Standard Batting) and is not detecting the Player Standard Batting. How do I resolve this issue? Happy to provide context and screenshots if those would be helpful

[#2 · Accepted solution]

@Collin__ 

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.

[#3]

@Collin__ 

Recently same connector appeared in Beta version of Excel 365. Hope it'll be generally available in a while.