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"
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
Hello Mynda
Are you aware of any special approach for non secure sites? Or it is just the same?
Leal
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"
