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 ti...
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 it
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 it
Hi stever78
That's not where [Timeout=#duration(0,0,20,0)] should go
Let's assume that your query Appends6 is the only one that gets data from the Web
Edit query Appends6. You should find a line that says something like:
xyz = ...Web.Contents("https://abcd...")change the above so it says:
xyz = ...Web.Contents("https://abcd...", [Timeout=#duration(0,0,20,0)])If you can get it to work please attach your workbook to your next reply please
- thanks for this LZ. I understand what your saying there. ill have to take a look because my web addresses are now stored in a cell. so the source in those queries gets the address from that cell.
getAddress . ill look into it and explain better. but i see what your saying here