Forum Discussion

Brass Contributor

Jul 22, 2021

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...

BI & Data Analysis

excel

Lorenzo

Silver Contributor

Jul 22, 2021

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

stever78

Brass Contributor

Jul 22, 2021

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