Hi Mynda
I was following your course '7.02 Scrape Data from Multiple Web Pages' and using the practice sheet pq_7.02. I replicated the function and the query but I kept getting the following error message so I could not upload the query result to the same workbook:
DataSource.Error: The Web.Page function didn't finish within timeout of 100 seconds.
Upon checking the steps of the query I found the following issues:
1) Source does not seem to change according to the changes in Table 1 of the practice sheet - I changed year to 2019 and added new-zealand to Table 1. I had to click on this step and fresh to effect changes;
2) There is a row of error at the end of country 2 or 3 - I suppose it is caused by the above time out problem but I am not sure.
Could you suggest some solutions to the above mentioned issues?
Thank you.
Kind regards,
Vivian
Hi Vivian,
Please share your Excel file containing your query with the error.
Mynda
Hi Mynda
I attach the file here.
It looks now the above 1) and 2) issues are gone but the error message is still there and possibly it has prevented the query from uploading the result to the same workbook.
Kind regards,
Vivian
Hi Vivian,
Thanks for sharing the file. Did you set the privacy settings to 'Public'? File > Options & Settings > Data Source Settings > Edit Permissions > Privacy Level = Public.
This is all I did, then refreshed and it loaded.
Mynda
Hi Mynda
Can you tell me how you changed the privacy settings? Where is the above 'Public'?File route?
I have set the privacy level to public when I was first prompted by 'Select Privacy Level For Data Sources' dialog box and then I never again saw this prompt later on when I tried to refresh.
I checked the data source settings in power query editor. B
oth the current workbook and https://www.timeanddate.com/ are set to public. I attach the photo.
Still I kept getting the same error message and could not load the file...
Best,
Vivian
Hi Vivian,
From power query editor window, go to File-Options and settings-Query Options. You will find there the privacy settings for the query, and more useful settings.
Hi Iasi and all
All my privacy settings are public but still I got the same error message and could not load my query result... Possibly it is not to do with the privacy settings at all?
Vivian
Try "Ignore privacy levels"
No I am afraid it is still not working... I have tried the answer sheet and I kept getting the same error message 'DataSource.Error: The Web.Page function didn't finish within timeout of 100 seconds'. Maybe power query has undergone some changes that make your query formulas not work? Can you please find some solutions to this? Do you need to build [Timeout=#duration(0,0,30,0)] somewhere into your formulas as some people suggested on the microsoft community website? I am so new to power query and I absolutely have no clues...
Hi Vivian,
There may be restrictions applied by the web server for incoming connections.
On first attempt, the query completed fast, no errors. But any subsequent refresh fails, so I suspect the error comes from the source, not from query.
If you need it, you can go for the paid version, they provide access keys without restrictions.
