Help, my PowerPivot for SharePoint Lists Atom Feed has fallen and it can’t get up!

One of the cool things with PowerPivot is to click on an SharePoint List’s Export as Data Feed (i.e. an Atom feed) and its data can be imported directly into a PowerPivot for Excel workbook.  To get this thing to work, one of the key things that I remind people regularly is to make sure you install  ADO.NET Data Services Update for .NET Framework 3.5 SP1.

So after doing this multiple times, I proceeded to do my usual atom feed import like I usually do:

Repro the issue

1) Go to my SharePoint List and click on Export as Data Feed

image

2)  When requested to do a File Download of the List.atomsvc file, click Open

image

3) Because you installed PowerPivot on your box, it will give you the option to import this Atom feed into an existing (e.g. Book1) or new workbook.  Choose appropriately and click OK.

image

4) It’ll provide you the Table Import Wizard so you can import your feed

clip_image001

5) Everything works like usual in terms of a PowerPivot data import

clip_image001[5]

.

What did I expect?

6) But instead of the nice message indicating that you had imported data properly:

image

so it shows up nicely in your PowerPivot workbook

image

.

What did I actually get?

7) you get this strange error message:

clip_image001[7]

in text this is:

For security reasons DTD is prohibited in this XML document.  To enable DTD processing set the ProhibitDtd property on XmlReaderSettings to false and pass the settings into XmlReader.Create method.

So how do I FIX this?

Thanks to John McConnell for reminding me that sometimes the solution is to do something simple (for context, I just had published the PowerPivot Security Architecture so my brain is still fried).

So the solution is to simply re-install ADO.NET Data Services Update for .NET Framework 3.5 SP1 again.  Yup, rather long bit of writing to simply say – install it again!

But there you have it Winking smile

9 thoughts on “Help, my PowerPivot for SharePoint Lists Atom Feed has fallen and it can’t get up!

  1. Pingback: Help, my PowerPivot for SharePoint Lists Atom Feed has fallen and it can’t get up! « PowerPivot Twins!

  2. Hello! I have re-installed ADO.NET services from new source(KB976127, 27/1/11, ver.3.5) and old(KB982307, 5/7/2010, ver.3.5), but get this message! Are you mean the re-installation as to uninstall hotfix and install again?

    • Hey Dimon,
      you shouldn’t need to uninstall the hotfix and re-install, a simple re-install should do the trick. If you’re still running into issues, I would suggest checking the PowerPivot for SharePoint forums so its possible to get some of the PFE or CSS folks involved.
      HTH!
      Denny

  3. Hello! We’ve got the same problem as Dimon. We installed KB976127 and old KB982307 on the server but the DTD security error stays…

    I can get a successful test connection from within the import table wizard in Excel

    @dennyglee when those hotfixes are installed on the server you cannot re-install them… windows says that they are already installed and exit the installer. Only way is to uninstall them and install again.

    maybe someone has an solution for this because it’s very frustating…

    • Sorry that you guys are continuing to run into this – I would suggest that you hit the PowerPivot for SharePoint newsgroups for this as if you’re running into the continual problems of uninstall/install then ther may be someother issues going on. Sorry that I could not be of more help on this one.

  4. I am having the same issues. I have installed the hotfix, uninstalled, reinstalled, and installed the old hotfix and I am still receiving this error when I try to open a list for an atom feed….

    • Sorry that you’re still running into issues about the oData feed. At this point, I would suggest hitting the PowerPivot for SharePoint or SharePoint Newsgroups and provide details about your error. Best of luck!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s