How to convert UNIX time to Date in PowerBI for Desktop
<p>I'm using "Document DB connector" for Power BI as a source of data. Due to limitation (there is not native support for dates) on Document DB we store dates in UNIX format (amount of seconds since 1970) that allows to write date range queries against Document DB.</p>

<p>The problem is to convert this back to date on Power BI side. I'm looking for possibility of creating Computed column that will convert epoch time to date. Otherwise we will be forced to write to Document DB in both formats that looks redundant.</p>

<p><a href="https://i.stack.imgur.com/APSaD.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/APSaD.png" alt="epoch time"></a></p>