We have a user that pulls 10 day forecast results from weather(DOT)com for multiple locations and every query has simultaneously stopped working around May 27, 2020. I have sample code referenced below. I can't post screenshots since I'm apparently not allowed to yet. Since nothing has changed on our end I am suspicious that IBM might have changed something on the website.
Note that this code used to work on Office 2016 and Office 2019. I tried Power BI Desktop and can pull the table there but the code it uses is incompatible with Excel.
let
Source = Web.Page(Web.Contents("(secure access to website)weather(DOT)com/weather/tenday/l/929a0a10df059030a591f46c408a7e6e022d06a80cdea1287444f02b92d9fd07")),
Data0 = Source{0}[Data],
#"Changed Type" = Table.TransformColumnTypes(Data0,{{"Day", type text}, {"Description", type text}, {"High / Low", type text}, {"Precip", type text}, {"Wind", Percentage.Type}, {"Humidity", type text}, {"Column7", Percentage.Type}}),
#"Split Column by Delimiter" = Table.SplitColumn(#"Changed Type", "Precip", Splitter.SplitTextByDelimiter("°", QuoteStyle.Csv), {"Precip.1", "Precip.2", "Precip.3"}),
#"Changed Type1" = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"Precip.1", Int64.Type}, {"Precip.2", Int64.Type}, {"Precip.3", type text}, {"Description", type date}})
in
#"Changed Type1"
Bookmarks