PowerPivot - Cannot create one to many relationship - Error: Type mismatch
<p>I have created a data model in Excel 2013 which consists of two queries:</p>

<ol>
<li>Table with 1 million rows of data. One of columns stores information on CUSTOMER_ID. </li>
<li>Table with 600 rows of data. This is a list of distinct CUSTOMER_IDs, but only VIP accounts.</li>
</ol>

<p>I wanted to create a one to many relationship between these CUSTOMER_ID columns but when I try to do so, I get the following error:</p>

<pre><code>============================
Error Message:
============================

The following system error occurred:  Type mismatch. 
Cannot convert value 'D: ControlTechSK4633-1' of type Text to type Integer.

----------------------------
The following system error occurred:  Type mismatch. 
Cannot convert value 'D: ControlTechSK4633-1' of type Text to type Integer.


============================
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.formCreateRelationshipDialog_Confirming(Object sender, EventArgs e)
   at Microsoft.AnalysisServices.Common.CreateRelationshipDialog.buttonOK_Click(Object sender, EventArgs e)

============================
</code></pre>

<p>Thank you in advance for the help.</p>