Results 1 to 7 of 7

Excel 2019 Query Randomly Stopped Working (The column 'Day' of the table wasn't found.)

Threaded View

  1. #1
    Registered User
    Join Date
    06-03-2020
    Location
    Montana
    MS-Off Ver
    2016, 2019, O365
    Posts
    3

    Excel 2019 Query Randomly Stopped Working (The column 'Day' of the table wasn't found.)

    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"
    Last edited by mste; 06-03-2020 at 02:39 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel 2013 stopped working while running MDX query
    By Mahesh.ms in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-28-2016, 07:14 AM
  2. the item with the specified name wasn't found
    By Ayoub99k in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-21-2015, 04:36 AM
  3. [SOLVED] Code randomly stopped working in versions other than Excel 2013
    By mlmusic in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-21-2014, 11:45 PM
  4. Errors: Microsoft Excel has stopped working - crash in pivot table
    By EvaLina in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-12-2014, 09:58 AM
  5. Web query has stopped working...
    By andrewm27 in forum Excel General
    Replies: 0
    Last Post: 04-20-2006, 12:28 AM
  6. [SOLVED] Remote data query stopped working
    By Mark Scholes in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-24-2005, 05:06 AM
  7. [SOLVED] query wizard has stopped working how do i rectify this
    By Marie LND in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-18-2005, 10:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1