S_Harrison_SD
Advocate I
4 months agoWeather Forecast using Power BI
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
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
3 Replies
- odeddror
Advocate I
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
- S_Harrison_SD
Advocate I
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
Advocate I
Thanks for sharing