Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Converting Unix timestamp to DateTime and NOT having to Import to accomplish this

Hi all you Power BI gurus!   Hope you can help the newbie out here...   I have attempted to convert from an SQL database the Unix timestamp and have done so...HOWEVER, it forces me to change my conne...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
8 years ago

Did you converted timestamp using dax expression? 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

I created a new column and used this as a formula, which worked, but made me change the connection type to Import.

#datetime(1970,1,1,0,0,0) + #duration(0,-5,0,[F_CRTM])

 

I tried to use a DAX formula but it gives me an error when I try to type in the field ([UnixTime] in the formula but I type in the field I want it to convert) right at field name and says it can't find it.   Below is the formula I was using.  

 

UTCTime = VAR UnixDays = [UnixTime]/(60*60*24)
RETURN (DATEVALUE("1/1/1970")+UnixDays)

 

Does this answer your question?

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    8 years ago

    Did you turned on "Allow unrestricted measure in direct query mode" if not then goto options and settings -> Option -> Direct Query , check the option.

     

    Try and see if it works

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      That option is already checked  :smileysad:  But thank you!   I did learn something new with your suggestion.   I did not know that was there.

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi,  wondering if this was ever resolved.  I'm facing the same issue and can't find a resolution.