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
add comment

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.