Error in Power Pivot

Question

Hi,

I have just added a new table to power pivot and when I try and link two fields with the same data type, I get the following issue;

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

Error Message:

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

An unexpected error occurred (file 'xmdatadict.inl', line 2275, function 'XMTypedOperator<unsigned short *>::ConvertData').

---

An unexpected error occurred (file 'xmdatadict.inl', line 2275, function 'XMTypedOperator<unsigned short *>::ConvertData').

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

Call Stack:

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

   at Microsoft.AnalysisServices.BackEnd.DataModelingSandbox.ExecuteCaptureLogAndProcessResults(OperationType type, Boolean cancellable, Boolean raw, Boolean raiseEvents)

   at Microsoft.AnalysisServices.BackEnd.DataModelingSandbox.ExecuteAMOCode(OperationType type, OperationCancellability cancellable, AMOCode code, Boolean raiseEvents)

   at Microsoft.AnalysisServices.BackEnd.SandboxTransaction.CommitUpdates()

   at Microsoft.AnalysisServices.BackEnd.SandboxTransaction.CommitInternal(Boolean finalCommit)

---

   at Microsoft.AnalysisServices.BackEnd.SandboxTransaction.CommitInternal(Boolean finalCommit)

   at Microsoft.AnalysisServices.Common.RelationshipController.CreateRelationship(DataModelingColumn sourceColumn, DataModelingColumn relatedColumn)

   at Microsoft.AnalysisServices.Common.RelationshipController.CreateRelationship(String fkTableName, String fkColumnName, String pkTableName, String pkColumnName)

   at Microsoft.AnalysisServices.Common.SandboxEditor.erDiagram_CreateRelationshipCallBack(Object sender, ERDiagramCreateRelationshipEventArgs e)

   at Microsoft.AnalysisServices.Common.ERDiagram.OnCreateRelationship(String fkTable, String fkColumn, String pkTable, String pkColumn)

   at Microsoft.AnalysisServices.Common.ERDiagram.ERDiagramActionCreateRelationship.Do(IDiagramActionInstance actionInstance)

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

Any help would be appreciated.

Best regards,

Brent

Answer 1

Hello Brent,

For better suggestion related to Power Pivot in Excel, you may post your query in Excel IT pro using the forum link below.

http://social.technet.microsoft.com/Forums/en/excel/threads

Thank you.