Forum Discussion

unknownuser's avatar
unknownuser
New Member
6 years ago

Plotting JSON data into a graph

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?

 

 

Need Help

1 Reply

  • dax's avatar
    dax
    Community Support
    6 years ago

    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.