Power Query "waiting for (website)"

Joined
Jun 13, 2017
Messages
108
Hi all, hoping someone can assist as I literally started using power query yesterday.

I'm pulling some data from a website using their API function (I've got an API key which is free and the key has not reached the allocated limit).
I've created a power query & filtered off what I don't need.
My problem is the query randomly decides to get stuck on "waiting for this website you're querying"
TEST.JPG

After a fair few minutes of the above I get this error:
1619465103598.png


HOWEVER - the data will sometimes pull through.
I also noticed the data will always pull through after I turn on my laptop in the morning.
And if it gets stuck on "waiting for", then a restart won't help, but a longer shutdown will. As though it's a cache problem?

I've done some looking online and no one seems to have the exact same issue, but I have tried some suggestions I thought may be relevant.
I've re-done this query with no filters, but I'm getting the same issue.
I've increased the cache memory on power query options to 9999 (up from 4000ish).
I've turned on "get data quickly".
Everything with the name "Microsoft" has been allowed through my firewall + "Excel" itself.

PLEASE, someone help me! I'm losing my mind :D

My source is:
Header=X-CMC_PRO_API_KEY
API Key= I don't think I should share that xD
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
RESOLVED!

Turns out it may have been AVG free antivirus somehow stopping the connection after a short delay every time.
Replaced AVG with another antivirus & have had no refreshing issues for 2 days now.
 
Upvote 0

Forum statistics

Threads
1,224,822
Messages
6,181,165
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top