Pulling data from Cloudflare protected website

xcelecx

New Member
Joined
Jun 29, 2017
Messages
1
Hello,
I've been using Power Query for a couple years to pull data from a website that has now suddenly gone to Cloudflare for DDOS attacks. Of course this has broken my web queries because when you go to a cloudflare protected website, it analyzes your browser for about 5 seconds and then continues to the site. When Power Query tries to connect it just hits a 503 "can't connect" error while it's doing this browser analysis. Has anyone ran into this before? Is there a workaround for this in Power Query, like some sort of delay before it tries to connect?

Thanks for any help
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Watch MrExcel Video

Forum statistics

Threads
1,114,048
Messages
5,545,711
Members
410,701
Latest member
anneau
Top