You can turn off the re-directions.
When you goto Data>>From Web>>
In the dialog click on "Options" on the top right corner.
Disable web query redirections from there.