S_Harrison_SD's avatar
S_Harrison_SD
Icon for Advocate I rankAdvocate I
4 months ago

Weather 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 

 

3 Replies

  • 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

  • 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