Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |