Results 1 to 2 of 2

Thread: Data Query from WEB ( Unexpected Error)
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Feb 2004
    Posts
    351
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Data Query from WEB ( Unexpected Error)

    Excel - Unexpected Error, Something went wrong. If the problem continues, please restart Excel.

    I am trying to create a web query, but it continues to fail. I can see the data from the table, but when try to load or edit, I get the Unexpected error.






    shared #"NavigatorBase_d7b1e33b-12e0-429d-a134-38aa64065c4a" = let
    Source = Web.Page(Web.Contents("http://xxxxxmetrics/investments/index?symbol=aapl"))
    in
    Source;


    Workaround

    I create a blank query then changed the Advanced editor

    let
    Source = Web.Page(Web.Contents("http://xxxxxmetrics/investments/index?symbol=aapl")),
    Data = Source{0}[Data],
    #"Changed Type" = Table.TransformColumnTypes(Data,{{"Symbol", type text}, {"Code", type text}, {"Description", type text}, {"Year", Int64.Type}, {"Quarter", Int64.Type}, {"Period Type", type text}, {"Value", type number}})
    in
    #"Changed Type"
    0 0
     

  2. #2
    MrExcel MVP
    Moderator

    Tracy's new best bud
    Jon von der Heyden's Avatar
    Join Date
    Apr 2004
    Location
    London, UK
    Posts
    10,680
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    4 Thread(s)

    Default Re: Data Query from WEB ( Unexpected Error)

    Duplicate: https://www.mrexcel.com/forum/power-...ml#post5320611

    Per the forum rules please address your questions through a single thread.
    Regards,
    Jon von der Heyden

    Posting guidelines | Forum rules | FAQs
    English is a weird language. It can be understood through tough thorough thought, though!
    0 0
     

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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