Convert data type E+12 to Time Stamp

[Anonymous]

Hello

I've used an API to pull New Relic data into Power BI and there is a column called Timestamp.1 which holds values that look like 1.5713E+12 and so forth. I tried converting to anything besides decimal number and it errors. 

Can I transform or add a new column to retrieve a time/date value? 

[Anonymous]

Hi, 
I see that you were able to pull data from New Relic to Power BI using an API. Could you please provide the detailed process? 
Thanks in advance! 🙂 

[Anonymous]

may I know how did you integrate with Power BI?

[VijayP]

You have to use Split Column option. CAn you please share 2 or 3 Exact Values in each cell. Then I can explain thru screenshots

[Anonymous]

Hi @VijayP 

Three values:

1571264722889

1571304319052

1571264722889

Strange I was able to get these by pasting into Excel, they converted to number no problem. Power BI will not allow me to convert the truncated value. 

Thanks for helping me!

Jemma

[Gordonlilj · Accepted solution]

Hi,

If you want to convert it to datetime you could try the solution provided in this post

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