The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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)