Forum Discussion
Solved
Problem Converting UNIX time power bi desktop
hi in this topic explain how to convert the unix time type into power bi desktop: https://community.powerbi.com/t5/Desktop/Converting-UNIX-time-to-Date-in-PowerBI-for-Desktop/m-p/132066#M5634...
Adjust the formula with -7 as hours in the #duration part:
#datetime(1970, 1, 1, 0, 0, 0) + #duration(0, -7, 0, [UnixTime]/1000)
