title: Change column type to Date in Power Bi
body: <p>I had added new table to my Power Bi file that contains a column with date with the following format: <code>dd/MM/yyyy</code> for example: 17/08/2017. </p>
  
  <p>In power Bi this column is Text type, and when I try to convert to date it came with the following error: </p>
  
  <pre><code>DataFormat.Error: We couldn't parse the input provided as a Date value.
  Details:
      17/08/2017
  </code></pre>
  
  <p>how can I change its type or format this text on new column and change the type if possible?</p>