Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Importing to Excel by Web Query

921569Mar 3 2012 — edited Mar 3 2012
I have searched many forums for an answer to my issue. I am working to have an Web Query setup from Oracle BI Answers to my Excel Source data for report presentation. When I have setup my Query and saved it I have set it to Bypass Oracle BI Presentation Services Cache. This then gives me the option to download a Web Query (*.iqy file). When I connect that to my workbook in Excel 2007, I get an error "Cannot locate Internet Server or proxy server." And it never prompts me for my Username and Password as everything has indicated it should.

Please help me. If there is another simple way to have a automatic refreshing Query setup to import into excel, I would also appreciate that info.

Thank you.

-Carl

Edited by: 918566 on Mar 3, 2012 1:12 PM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 31 2012
Added on Mar 3 2012
0 comments
543 views