PowerPivot Datamarket Place and Proxy Authentication

Question

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

<?xml version="1.0"?>
<configuration>
 <startup>
  <system.net>
   <defaultProxy enabled="true" useDefaultCredentials="true" >
    <proxy autoDetect="true" usesystemdefault="true"/>

   </defaultProxy>
  </system.net>
 </startup>
</configuration>

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.

Answer 1

Hi,

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 

Thanks,

---

Challen Fu

TechNet Community Support

Answer 2

Was there any updates for this issue as I get the same problem when trying to connect to any data feeds from the Data Market.

Answer 3

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:

   <defaultProxy enabled="true" useDefaultCredentials="true" >
    <proxy autoDetect="true" usesystemdefault="true"/>

   </defaultProxy>

Please help us resolve these issues in this forum so that others may also find the solution.

Cheers,

Scott

---

I suppot PASS - www.SQLPASS.org

Answer 4

Do you get any solution for the above query.?

Answer 5

Any updates?

Answer 6

I'm unable to add the proxy information anywhere in the PowerPivot UI. Need to address this quickly.

Answer 7

Hi,

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).

Thanks,
AC

Answer 8

Hi again,

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!