title: Problem creating unique values to create a relationship in Power BI
body: <p>I'm trying to join two tables together through a relationship but am having trouble. </p>
  
  <p>My data is of a Building (type text) , which has Floors and Rooms which can both be a mix of text and number names (type any).  </p>
  
  <p><a href="https://i.stack.imgur.com/ocl4V.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ocl4V.jpg" alt="enter image description here"></a></p>
  
  <p>In order to create a relationship based on the Room column, I attempted to create a unqiue values table by referencing the Room_Mapping table, removing all by columns apart from Room, and removing duplicates. </p>
  
  <p><a href="https://i.stack.imgur.com/ArbbC.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ArbbC.jpg" alt="enter image description here"></a></p>
  
  <p>However, when I try to join the two tables together based on the Room column, I keep getting the following message. </p>
  
  <p><a href="https://i.stack.imgur.com/lDTEo.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/lDTEo.jpg" alt="enter image description here"></a></p>
  
  <p>I have a feeling that this error is coming because the data type is a mix of text and numbers that it is getting confused because when I go to look at the data in Data view, I can see that the data for Phase and Room fields have been converted to Text type.  </p>
  
  <p><a href="https://i.stack.imgur.com/LPHyk.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/LPHyk.jpg" alt="enter image description here"></a></p>
  
  <p>Please can any one help?  I have attached a link to the workbook and data in the link below.</p>
  
  <p><a href="https://drive.google.com/open?id=1EgA0qNKE_h3A0kJQHMt3t-qlMb2LSiV3" rel="nofollow noreferrer">Room_Mapping Data and PBI Workbook</a></p>
  
  <p>Many thanks in advance.</p>