Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register 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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
34 | |
30 | |
18 | |
12 | |
8 |
User | Count |
---|---|
50 | |
35 | |
30 | |
14 | |
12 |