Get / Post Method returns <META NAME="robots" CONTENT="noindex,nofollow">

Hi kkapsokavadis 

The website you're trying to access is being protected by a web firewall from Imperva/Incapsula and your requests are being recognised as an automated request which triggers Incapsula's challenge page. 

That's what the code you see in the image above - specifically it loads a JavaScript script to request a response.  Basically it's asking you to tick a box to say you are not a bot.

Of course the PQ request can't do this so your query fails.

POSTMAN is a well known piece of software and web firewalls like Incapsula recognise it so it doesn't trigger these challenges.

Unfortunately the same can't be said for Power Query/PBI.

There are only 2 solutions I can think of:

1. Contact the API provider and get them to whitelist your IP address in their Incapsula firewall

2. Contact Incapsula and ask them how you can get around this problem.

Regards

Phil

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.