Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Scraping Table Data


I am trying to pull some information on the swimming at the 2008 Summer Olympics from wikipedia 


The event information is structured in a consistent format eg:-






So i have produced a function to scrape each page. When connecting to the intial page I selected the 'Heats' table,  believing that this would identify the table to connect to for all the subsequent pages.





When looking at the source this isn’t the case, it seems to have stored the original table using its position on the page. This means that the data doesn’t pull through on the majority of tables, as the table doesn’t fall in the same place on the page as the original.


Is there any way I can direct the original query to the Heats table, such that if finds the Heats table on all the other pages? Anything I’ve written in the advanced editor so far fails! Also if there are any online resources on this particular problem I would really like to look into them, everything I have viewed on youtube only concerns connecting to different pages, and not how to connect to specific tables within those different pages.



Super User III
Super User III

I'd recommend you learn about the HTML DOM


JavaScript DOM Methods (

Thanks, will look through this

Super User III
Super User III

Have you considered parsing the HTML instead? The Heats section seems to be identifiable by the span id.




Thank you for the response, do you know of any good online resources I could use to upskill on this? I'm at the edge of my understanding so need to learn more before I can attempt anything more complexed

Helpful resources

PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors