View the original community article here
Last tested: Mar 30, 2018
It's only possible to download an iqy file on a Look with Public Access turned on.
- Turn on Public Access for the Look as specified in this doc.
- Once you save that, the bottom option "Excel Web Query File" should have a "Download" link next to it!
- This doc has info on what to do now that you've downloaded the iqy file.