10 февраля 2012 г. 10:32
How do you get PowerPivot to use the default proxy settings in IE when connecting to external data sources, for example the Azure Data MarketPlace? I have tried adding an EXCEL.EXE.config file with the following but it has had no effect
<defaultProxy enabled="true" useDefaultCredentials="true" >
<proxy autoDetect="true" usesystemdefault="true"/>
Whenever I try to connect to an external source I get a proxy authentication error. I am using the latest 2012 RC0 version on PowerPivot.
13 февраля 2012 г. 6:50Модератор
In order to further troubleshot your issue, could you please supply more information? such as:
1. What's your Data Feed URL?
2. In which steps you have the error? What't the whole Error message?
Besides, I would recommend open this link to get some reference about how import Azure Marketplace Data into PowerPivot http://jamiemaclennan.blogspot.com/2011/01/cleaning-azure-marketplace-data-with.html
TechNet Community Support
13 апреля 2012 г. 1:43Was there any updates for this issue as I get the same problem when trying to connect to any data feeds from the Data Market.
17 апреля 2012 г. 23:24
I too get a "(407) Proxy Authentication Required" attempting co connect to http://services.odata.org/Northwind/Northwind.svc/Customers With PowerPivot 2012 for Excel on my corporate PC at work, while it works fine from home on the same software and connection. I see that Brynn has discovered what I have through my recent searches; we were told these elements are required:
Please help us resolve these issues in this forum so that others may also find the solution.
I suppot PASS - www.SQLPASS.org
2 мая 2012 г. 10:16
Do you get any solution for the above query.?
28 августа 2012 г. 10:03Any updates?
28 августа 2012 г. 10:08I'm unable to add the proxy information anywhere in the PowerPivot UI. Need to address this quickly.
29 января 2013 г. 17:36
Sorry to bring up this old thread again but this is quite a big hindrance for me at the moment.
I have exactly the same issue as Scott described using PowerPivot 11.0.3000.0 behind a corporate proxy. Opening the data feed in question (json fromat) in a browser window is not an issue at all, neither is connecting to the data feed from home (no proxy).
31 января 2013 г. 11:09
For me the issue was resolved adding the following to an "Excel.exe.config" file:
<?xml version="1.0" encoding="utf-8" ?> <configuration> <system.net> <defaultProxy useDefaultCredentials="true"> <proxy usesystemdefault="true"/> </defaultProxy> </system.net> </configuration>
Using Office 2010, hope this helps someone!