title: How do I convert milliseconds into DateTime in Power Bi?
body: <p>I have a table that has 13 digit timestamps (milliseconds I believe) but I can't convert them in Power Bi for some reason. I've looked at many methods online and it should work but I keep getting an error each time I try to convert. (This is from transform data and after adding a custom column)</p>
  <p><a href="https://i.stack.imgur.com/tkFAd.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/tkFAd.png" alt="enter image description here" /></a></p>
  <p>When I try to convert the timestamps in &quot;created&quot; column into a new custom column I get an error. This is the formulae I use when creating a new column.</p>
  <pre><code>#datetime(1970, 1, 1, 0, 0, 0) + #duration(0, 0, 0, [Created]/1000)
  </code></pre>
  <p>This apparently works for other people who have the same problem but not for me and I'm not sure why that is, I just keep getting Errors.</p>
  <p>Any help would be appreciated.</p>