Forum

Web Query Refresh F...
 
Notifications
Clear all

Web Query Refresh Fails (probably a 500 error) - "Retry" procedure with Value.WaitFor not working

3 Posts
2 Users
0 Reactions
142 Views
(@kloepper-paulgmail-com)
Posts: 2
New Member
Topic starter
 

I've been having trouble getting web power query 'Value.WaitFor' function to work. My Excel 365 doesn't like something that I'm doing in the Advanced Editor.
I have some web pages that are slow to return data, so this code is supposed to retry the refresh (this m-code is being called from some VBA in the workbook). See attached workbook

Main code to look at: Helper_Wait_For_Retry and fxValue_WaitFor are combined in this code, Table0_WSJ_Qtr_Inc_WAIT

. Thanks, Paul

 
Posted : 18/01/2023 1:27 pm
Riny van Eekelen
(@riny)
Posts: 1195
Member Moderator
 

If you intended to add a file with the code "to look at", please try again. This time, press "Start upload" before you submit your reply.

 
Posted : 19/01/2023 3:45 am
(@kloepper-paulgmail-com)
Posts: 2
New Member
Topic starter
 

here are the files, hopefully...Paul

 
Posted : 19/01/2023 4:21 pm
Share: