title: Excel power query : handle column containing both number and text /xlookup returns #REF upon refresh
body: <p>I am using power query to pull data for our sharepoint. I am having an issue with a column containg IDs which are a mix of whole numbers and texts. I need to use the column with xlook up to fill data to another spreadsheet. But the look up does not work as the numbers are also considered as text. Do you know how I can handle the data type in power query so that the number are acknowledged as number and the text as text?</p>
  <p>Another thing, whenever I refresh the query my formula returns a reference error. Is there a way to avoid this happening?</p>
  <p>Thanks for your help</p>