Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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)
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! 🙂
may I know how did you integrate with Power BI?
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
Proud to be a Super User!
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
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)