Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
unknownuser
New Member

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:

 

poweribi.png

 

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

 

powerbi2.png

 

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?

 

 

1 REPLY 1
dax
Community Support
Community Support

Hi unknownuser,

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

427.PNG

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.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.