Forum Discussion
datasource.error the web page function didnt finish within timeout of 100 seconds
Hi, appreciate if anyone can help with this
i have a workbook with 110 queries on it.
when i refresh all i get the above error being
"datasource.error the web page function didnt finish within timeout of 100 seconds"
is there a fix to this??
Also,
being that i have lots of queries, and i do need to "refresh all" at times
should i have
"Enable background refresh" ON or OFF ??
also, should i have
"Enable Fast data load" ON or OFF ??
i dont know if these have anything to do with the above error i am getting?
thanks very much for your help
steve r
9 Replies
You may try to add Timeout parameter like
= ...(Web.Contents("URL", [Timeout=#duration(0,0,20,0)])),...(20 min is here)
- Hello Sergei, thanks for reply.
i did try to add that to my table but it didnt allow it. it said token rightbracket expected.
also, all of those seem to be where the query source is from the web.
wheres my query source is to append 6 other tables. ( although they get thier source from the web )
so im not sure if that works for my query.
however
i added it like this
let
Source = Table.Combine({AppendS1, AppendS2, Appends3, Appends4, Appends5, Appends6}[Timeout=#duration(0,0,20,0)])),
#"Removed Duplicates" = Table.Distinct(Source, {"Column1"}),
#"Sorted Rows" = Table.Sort(#"Removed Duplicates",{{"Column1", Order.Ascending}})
in
#"Sorted Rows"
but when i click show error it points me to the = sign after the timeout
not sure whats going on really with itTimeout is the optional parameter for Web.Contents() Web.Contents - PowerQuery M | Microsoft Docs , not for Table.Combine(). Error says you have timeout error querying some them.
As for your code I'd recommend to add Index column after Table.Combine() to fix table in memory, after that sort, after that remove duplicates and after that remove Index column.
