Forum Discussion

harshali's avatar
harshali
Frequent Visitor
9 years ago
Solved

Error message when converting unix time

I have a dataset coming from an SQL server in PowerBI. The dataset is currently 21,000+ rows. There is a column that has a Unix timestamp which I am trying to convert to regular timestamp. I am using...
Need Help
  • v-caliao-msft's avatar
    v-caliao-msft
    9 years ago

    harshali,

     

    You can add a custom column

    #datetime(1970, 1, 1, 0, 0, 0) + #duration(0, 0, 0, [UnixTime]/1000)

     Capture.PNG

     

    Regards,

    Charlie Liao

v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
9 years ago

harshali,

 

You can add a custom column

#datetime(1970, 1, 1, 0, 0, 0) + #duration(0, 0, 0, [UnixTime]/1000)

 Capture.PNG

 

Regards,

Charlie Liao

rasiksawant09's avatar
rasiksawant09
Regular Visitor
2 years ago

Thanks a lot.