Home » SQL ServerRSS

Pasting Data Failed error when linking Excel table

I get an error "data paste failed" when trying to link an Excel table to PowerPivot.  I just installed Office 2010 and Powerpivot.  Below is a dump from the error box.

 

============================
Error Message:
============================

The object does not exist or read permissions are needed.
----------------------------
Pasting data failed.

============================
Call Stack:
============================

   at Microsoft.AnalysisServices.Server.Refresh(IMajorObject obj, ObjectExpansion expansion)
   at Microsoft.AnalysisServices.Server.SendRefresh(IMajorObject obj, ObjectExpansion expansion)
   at Microsoft.AnalysisServices.MajorObject.Refresh(Boolean full)
   at Microsoft.AnalysisServices.Modeler.Storage.PushedDataTable.TryChangeColumnDataTypes(PushedDataInfo pushedDataInfo, PushedDataSource pushedDataSource)
   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()

 

1 Answer Found

 

Answer 1

Did You get a solution?
 
 
 

<< Previous      Next >>


Microsoft   |   Windows   |   Visual Studio   |   Follow us on Twitter