Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.