Log In
Register
Home
New Member
May 1, 2019
Offline
I have below m code which is working perfectly in query editor, table was fetched with no issue. However, unable to load the table to excel sheet. Im not sure if there is something special with this website as i didnt face this problem with other sites.
Appreciate to have some advise to sort this problem
let
Source = Web.Page(Web.Contents("http://edge.pse.com.ph/disclosureData/dividends_and_rights_info_form.do")),
Data = Source{0}[Data],
#"Changed Type" = Table.TransformColumnTypes(Data,{{"Company Name", type text}, {"Type of Security", type text}, {"Type of Dividend", type text}, {"Dividend Rate", type text}, {"Ex-Dividend Date", type date}, {"Record Date", type date}, {"Payment Date", type date}, {"Circular Number", type text}})
in
#"Changed Type"
July 16, 2010
Offline
Hi Leal,
Welcome to our forum.
I'm unable to load the data from that site too. It reports a time out error, so it's possible the website is preventing the data being downloaded. I'm not sure, sorry.
Mynda
New Member
May 1, 2019
Offline
Hello Mynda
Are you aware of any special approach for non secure sites? Or it is just the same?
Leal
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Offline
Hi,
All you can do is to increase the timeout value:
Source = Web.Page(Web.Contents("http://edge.pse.com.ph/disclosureData/dividends_and_rights_info_form.do",[Timeout=#duration(0,0,10,0)])),
(that means 10 minutes)
I received the error: "An unknown error occured when navigating to web page"
1 Guest(s)
