"Pasting data failed" when importing Excel data into PowerPivot for Excel.

    General discussion

  • I have a sheet with approximately 55,000 records from a customer in Excel format. When I highlight the range and click "Create a linked table" I get the following error...

    Pasting data failed.

    The details are...

    Error Message:

    XML parsing failed at line 7004, column 34: Illegal xml character.
    Pasting data failed.

    Call Stack:

       at Microsoft.AnalysisServices.Modeler.Storage.DataModelingSandbox.ExecuteRawCaptureLogInBackground(OperationType type, Boolean cancellable)
       at Microsoft.AnalysisServices.Modeler.Storage.DataModelingSandbox.ExecuteCaptureLogAndProcessResults(OperationType type, Boolean cancellable, Boolean raw)
       at Microsoft.AnalysisServices.Modeler.Storage.DataModelingSandbox.ExecuteCustomBuiltXmla(OperationType type, OperationCancellability cancellable, XmlWriterCode code)
       at Microsoft.AnalysisServices.Modeler.Storage.PushedDataTable.PushDataChunk(String sessionId, Dimension dimension, Object[][] data, PushedDataInfo pushedDataInfo)
       at Microsoft.AnalysisServices.Modeler.Storage.PushedDataTable.PushData(String sessionId, Dimension dimension, PushedDataSource pushedDataSource, PushedDataInfo pushedDataInfo, Dictionary`2 columnOrderMap)
       at Microsoft.AnalysisServices.Modeler.Storage.PushedDataTable.CreateLinkedTableInternal(CreateTableParameters parameters)
       at Microsoft.AnalysisServices.Modeler.Storage.PushedDataTable.CreateLinkedTableInternal(CreateTableParameters parameters)
       at Microsoft.AnalysisServices.Modeler.Storage.PushedDataTable.CreateLinkedTable(String tableName, IExcelTableDataReader excelTableReader)
       at Microsoft.AnalysisServices.Modeler.Storage.DataModelingSandbox.CreateLinkedTable(String tableName, IExcelTableDataReader excelTableReader)
       at Microsoft.AnalysisServices.Modeler.ClientWindow.CreateLinkedTable()


    I have seen another forum post with this same error and have followed the instructions given - copy the data out to Notepad and copy back to remove unprintable characters - but this hasn't worked.

    I've also tried copying to Notepad, saving the text file and re-importing the file into Excel. This new file also causes the same error on exactly the same column and row.

    Finally I've tried opening PowerPivot and tried importing the text file as an external source. This reads without a problem, but now I can't work out how to create linked tables for the dimensions.

    I've also tried removing the offending row of data and even removed the entire column but the error persists. In fact even if I remove a lot of rows and columns I still get an identical error on the same row and column.

    Please can you take a look at this and see if this is a bug with the using Excel as a source or whether I am doing something wrong?

    Tuesday, March 15, 2011 4:42 PM

All replies

  • Which PP version are you using and what are the settings in "Regional and Language Options" of Windows?
    Eddy N.
    Friday, March 18, 2011 8:44 AM
  • Excel 2010 14.0.5128.5000 (32 bit) running on Windows 7 Enterprise Service Pack 1 (64 bit) with the PowerPivot 10.50.1747.0 add in installed. I am a "Regular Privilege User". The PC is an Intel Core i3 2.4GHz with 4.00GB RAM.
    Thursday, July 07, 2011 9:51 AM
  • Tababi,

    Is this still an issue?

    Thank you!

    Ed Price, SQL Server Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

    Answer an interesting question? Create a wiki article about it!

    Sunday, November 03, 2013 10:25 PM