Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

When importing data from an atom feed in PowerPivot, I get the following error:

XML parsing failed at line 7, column 727: Semicolon expected.

The feed currently only returns two entries, and PowerPivot's "Preview & Filter" feature has no problems displaying these entries. However, when attempting to import the rows, PowerPivot reports the error above.

I am using the latest version of PowerPivot for Excel 2010.

What could be causing this error?

Other information:

  • I tried saving the raw XML from the feed to a file - PowerPivot reads this "feed" just fine!
  • Basic authentication (user/password) is required to access the feed.
  • I suspected it might have to do with my locale settings (Denmark), but changing these to United States had no effect.
  • I have validated the raw feed contents using the Atom Feed Validator, and it comes out valid.
  • I tried locating the position to which the error refers, but the whole XML feed is returned without insignificant white space, i.e. as a single line. Where is line 7 then?

All of the above makes me think that this has nothing to do with the feed itself, but how PowerPivot handles the feed.


Update: This error doesn't occur on our client's computer, thus confirming that the problem lies within PowerPivot and not the feed.

share|improve this question

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.