Error: XML parsing failed at line [NUMBER], column [NUMBER]: Semicolon expected

After pasting your odata link, entering credential in advanced, and clicking Finish in the Table Import Wizard when loading an odata link in PowerPivot; you may receive the error XML parsing failed at line [NUMBER], column [NUMBER]: Semicolon expected.
 This is most likely happening do to missing components in windows. Please ensure that the following components are installed
  1. Click Start>Control Center>Programs>Programs and Features and look for Microsoft .NET Framework 4.0 or Microsoft .NET Framework 4.5.1. Either one of these will work. If they are both missing; install 4.5.1
  2. In Programs and Features, also look for Visual Studio 2010 Tools for Office Runtime. If Missing; install from link. This is required even if you are using Office 2013 or Office 360
  3. You will also need to enable Microsoft .NET Programmability Support with the steps below.
    1. Click the Windows Start button, and choose Settings > Control Panel.
    2. In the Control Panel, select and open Add or Remove Programs.
    3. Select the entry in the Add or Remove Programs dialog for Microsoft Office and click Change.
    4. In the Microsoft Office dialog, choose Add or Remove Features, and click Continue.
    5. In the Installation Options page, expand Microsoft Office Excel.
    6. Select .NET Programmability Support, and choose Run from My Computer from the dropdown list

 

 

Environment

 3.18

Was this article helpful?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.