Plotting JSON data into a graph

[unknownuser]

Hi,

I've managed to query and combine some data from rest api's into Power Bi and am currently looking a situation like this:

In the JSON record there is just unix timestamps and temperature in celsius:

I dont know how to open this data from here.. i'm thinking of making a new table with id column repeating in front of timestamp (converted to date) and the temperature (so far havent figured out how to do it) but maybe there is some better way?

[dax]

Hi unknownuser,

If you want to open record in desktop, you could click expand in record column

If this is not what you want, please corret me and explain it in details.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.