Pasting data failed error? plz help

[sagar89]

---

i am using excel 2010 powerpivot addin 32 bit
i have data in excel of ~75000 rows.
the columns have date, numbers, text, etc. type of data.
when i click create linked table, i get this error- Pasting data failed.
plz help..( i want to create linked data because the data changes with every month and the pivot table/charts needs to be updated accordingly).

.

---

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


Either the dimension with the ID of 'Table4' does not exist in the database with the ID of '9CA87BA19B6543B4A964', or the user does not have permissions to access the object.
----------------------------
An error occurred during pipeline processing.
----------------------------
Pasting data failed.


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




----------------------------
at Microsoft.AnalysisServices.BackEnd.DataModelingSandbox.ExecuteRawCaptureLogInBackground(OperationType type, Boolean cancellable, Boolean raiseEvents)
at Microsoft.AnalysisServices.BackEnd.DataModelingSandbox.ExecuteCaptureLogAndProcessResults(OperationType type, Boolean cancellable, Boolean raw, Boolean raiseEvents)
at Microsoft.AnalysisServices.BackEnd.DataModelingSandbox.ExecuteCustomBuiltXmla(OperationType type, OperationCancellability cancellable, XmlWriterCode code, Boolean raiseEvents)
at Microsoft.AnalysisServices.BackEnd.PushedDataTable.EndPushingData(String sessionId, Dimension dimension, PushedDataInfo pushedDataInfo)
at Microsoft.AnalysisServices.BackEnd.PushedDataTable.PushData(String sessionId, Dimension dimension, PushedDataSource pushedDataSource, PushedDataInfo pushedDataInfo, Dictionary`2 columnOrderMap)
at Microsoft.AnalysisServices.BackEnd.PushedDataTable.CreateLinkedTableInternal(CreateTableParameters parameters)
----------------------------
at Microsoft.AnalysisServices.BackEnd.PushedDataTable.CreateLinkedTableInternal(CreateTableParameters parameters)
at Microsoft.AnalysisServices.BackEnd.PushedDataTable.CreateLinkedTable(String tableName, IExcelTableDataReader excelTableReader)
at Microsoft.AnalysisServices.BackEnd.DataModelingSandbox.CreateLinkedTable(String tableName, IExcelTableDataReader excelTableReader)
at Microsoft.AnalysisServices.XLHost.Modeler.ClientWindow.CreateLinkedTable()


============================

 

[scottsen]

Can you get your data into a CSV and import it that way? If nothing else, you might find a weird issue w/ your data during that process, but you can also just refresh your data in powerpivot from an updated csv file each month?

 

[sagar89]

thanks for the reply
i did a clean() and now the data gets linked..but still some problems, because the file size has increased and taking a lot of time to open or save.