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





Was this article helpful?