troubleshooting power query timing out on a web page acces

ppblais

New Member
Joined
Jul 23, 2020
Messages
1
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
I have a document that is pulling a lot of data from a webpage table.
This morning it was working fine, I hit the refresh all button, it did it's think, and everything updated just fine, like it did the day before, etc.
But later in the same day I did the same thing but now I get :

DataSource.Error: The Web.Page function didn't finish within timeout of 100 seconds.

My initial instinct was that something was wrong with the webpage table, but when I copy the link into a browser the table loads up just fine, and fairly quickly.
I also generated new webpage tables and updated the links to match, and still the same error message.

So next I increased the timeout to something crazy like 30min to see if it eventually pulled something from the page. this time it didn't timeout, but reported a new type of error which I am unfamiliar with:
(sorry for the x's but I can't share the actual address because confidential, etc.)

DataSource.Error: An unknown error occurred when navigating to the web page.
Details:
DataSourceKind=Web
DataSourcePath=https://xxxxxxxxxxxxxxxxxxx
StatusCode=524


so I am not sure I understand what is going on... I am not an expert in excel and the document in question was created by someone else more knowledgeable then me in this regard and who is unfortunatly no longer available to help figure it out.
I know these error messages can mean a number of things, I am just not sure where to go next in my troubleshoot beyond the steps I've outlined above.
it might just be something very simple I am not thinking of because I just don't understand the process well enough yet.
any help pointing me in the right direction will be greatly appreciated.
 

Some videos you may like

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Watch MrExcel Video

Forum statistics

Threads
1,113,836
Messages
5,544,596
Members
410,624
Latest member
smartsanjiv64
Top