Forum Discussion

AlbertMaes's avatar
AlbertMaes
Regular Visitor
7 years ago
Solved

Java Long Date does not convert to time in query editor

Hi there,   new to the forum and new to data modelling...   I am connecting to a PostGres Database of our ticketing system (ManageEngine ServiceDesk) where timestamps are stored in what i assume ...
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi,@AlbertMaes

       You can add a calculate column when you modeling like this

    Date = DATEVALUE("1970-1-1") + (Table1[Column1]/(60*60*24*1000))

    Result:

     

    Best Regards,

    Lin

AlbertMaes's avatar
AlbertMaes
Regular Visitor
7 years ago

I did some more digging here and it seems that indeed my database churns out Java Date Stamps (Day 0 = 01/01/1970), PowerBI seems to expect SQL Date Stamps (Day 0 = 12/12/1899)

 

How do I tell PowerBI to use a different date stamp?