Hi,

i am trying to refresh all power queries using this code:

Please Login or Register  to view this content.
the problem is that only one query is refreshed and macro stopped.
Only working when BackgroundQuery is set up to True.

But in this case my queries still refrehing in backround and i am getting msgbox "Done" (in background queires are working).
Macro is not waiting to refresh all power queries.

Did you have any issues with that?
I read that disabling background refresh should do the macro but it is not working for me.

Please Help,
Jacek