Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
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.
Thanks
Tom
Thanks, will look through this
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.