Weather Forecast using Power BI 05-07-2026 03:04 AM - last edited 05-07-2026 03:06 AM

[S_Harrison_SD]

From API to Dashboard: Live Weather Reporting in Power BI
A practical, beginner-friendly guide demonstrating how to connect Power BI to a free weather API (Open-Meteo) and transform live JSON data into a clean, structured dataset. The walkthrough covers building API queries, shaping data with Power Query, and creating a fully interactive dashboard using KPI cards, trend visuals, and slicers. It highlights how to turn real-time data into meaningful insights, making it an ideal example of combining APIs, data modeling, and report design in Power BI

You can follow the guide here
From API to Dashboard: Create a Live Weather Report in Power BI 

eyJrIjoiOTk4M2Q4NmYtOGM4NS00YmQ3LTgzNjktMjhkYzI5ZmNhNDgwIiwidCI6ImI4YjFhODkwLTg0ZGYtNDVjMy1hZjI2LTM4NjExMDA5NDZkNiJ9

[S_Harrison_SD]

Thanks Oded

We used a radar chart from the marketplace (Radar Chart 3.1.3.0)

Then we added a small compass directions table to control the sort order

Other than that fairly straight forward, I just thought it was a good way to show the data

PBIX file is attached if you want to take a look

thanks again

Simon

[odeddror]

Thanks for sharing

[odeddror]

Nice job, where did you get wind direction in page 4 radar chart (N, NE, NW Etc..)?
Or if you want to share your PBI as well?

Thanks,

Oded Dror