[VBA and Macros, Microsoft 2019] Reading data from website not working

[Mahar92]

Hello everybody!

I am not sure if this is the right place, so please be kind with me!

I am currently working with the "Microsoft Excel 2019 VBA and Macros" book. In the first part of Chapter 18 (Reading from and writing to the web) data is imported via Power Query
from the website wunderground.com. I am trying to replicate the technique, but it does not quite work.

Picture 1: Data I am getting when using the workbook provided with the book
Picture 2: Dataset found in the official workbook. Presumably, this is how the data imported from the website is supposed to look like.
Picture 3: After changing the URL (because I think it has changed since the book was released) from "URL;Local Weather Forecast, News and Conditions | Weather Underground" to North Canton, OH Weather History | Weather Underground, this is the data I am getting.

Is it my fault that this is not working or has the website changed over time date scrapping data is not possible anymore?





Kind regards,

Malte

 

[Mahar92]

Not sure how to edit my post, but these are the URLs (which don't show properly above):

Book URL: http://www.wunder ground.com/history/airport/KCAK//2019/6/27/DailyHistory.html
My Url: https://www.wunder ground.com/history/daily/KCAK/date/2019-6-27/DailyHistory.html