March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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
Solved! Go to Solution.
Hi @sirisha224,
I think you not add optional parameter to right place, it should add into web.contents function and use '[]' to package.
Sample:
Web.Contents("web url", [Timeout=#duration(0, 0, 0, 30)])
#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
Hi @sirisha224,
I think you not add optional parameter to right place, it should add into web.contents function and use '[]' to package.
Sample:
Web.Contents("web url", [Timeout=#duration(0, 0, 0, 30)])
#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
Thank you. It worked.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
40 | |
26 | |
17 | |
11 | |
10 |
User | Count |
---|---|
58 | |
52 | |
23 | |
14 | |
11 |