The Web.Page function didn't finish within timeout of 100 seconds

[sirisha224]

Hi,

I am trying to combine the data in 3 similarly structured tables using 'Append query' option and getting the 'Timeout within 100 seconds' error. The 3 similarly structured tables have data retrived from Web. I read in other blogs to add "Timeout=#duration(0,0,30,0)," code to solve the issue but it is not working in this scenario. Below is the code for the 3 tables I am trying to append.

Table 1

let
    Source = Web.Page(Web.Contents("http://www.xyz.com/p1")),
    Data1 = Source{1}[Data],
    Timeout=#duration(0,0,30,0),
    #"Changed Type" = Table.TransformColumnTypes(Data1,{{"Title", type text}, {"Updated", type text}, {"Last By", type text}, {"Comments", Int64.Type}}),
    #"Removed Errors" = Table.RemoveRowsWithErrors(#"Changed Type"),
 

in
   #"Removed Errors"

Table 2

let
    Source = Web.Page(Web.Contents("http://www.xyz.com/p2")),
    Data0 = Source{0}[Data],
    Timeout=#duration(0,0,30,0),
    #"Changed Type" = Table.TransformColumnTypes(Data0,{{"Title", type text}, {"Updated", type text}, {"Last By", type text}, {"Comments", Int64.Type}}),
    #"Removed Errors" = Table.RemoveRowsWithErrors(#"Changed Type")
in
    #"Removed Errors"

Table 3

let
    Source = Web.Page(Web.Contents("http://www.xyz.com/p3")),
    Data0 = Source{0}[Data],
    Timeout=#duration(0,0,30,0),
    #"Changed Type" = Table.TransformColumnTypes(Data0,{{"Title", type text}, {"Updated", type text}, {"Last By", type text}, {"Comments", Int64.Type}}),
    #"Removed Errors" = Table.RemoveRowsWithErrors(#"Changed Type")
in
    #"Removed Errors"

Thank you for your help.

Sirisha

[v-shex-msft · Accepted solution]

Hi @sirisha224,

I think you not add optional parameter to right place, it should add into web.contents function and use '[]' to package.

Web.Contents

Sample:

Web.Contents("web url", [Timeout=#duration(0, 0, 0, 30)])

#duration

#duration(days as number, hours as number, minutes as number, seconds as number) as duration

Modified query sample:

let
    Source = Web.Page(Web.Contents("http://www.xyz.com/p1",[Timeout=#duration(0, 0,0, 30)])),
    Data1 = Source{1}[Data],
    Timeout=#duration(0,0,30,0),
    #"Changed Type" = Table.TransformColumnTypes(Data1,{{"Title", type text}, {"Updated", type text}, {"Last By", type text}, {"Comments", Int64.Type}}),
    #"Removed Errors" = Table.RemoveRowsWithErrors(#"Changed Type"),

Regards,

Xiaoxin Sheng

[sirisha224]

Thank you. It worked.