I think I have found a weather data source from the Australian Bureau of Meteorology (BOM). I’ve been chatting to someone on the phone who was very helpful with giving me all the information except for how to bring the data into Power BI. Here’s a copy of the main information they sent through. They also sent me through a temporary password as well that we could use for the live data. If you send me your email I can send you the password as it updates every Tuesday of the next month.
I’ve kind of brought in the XML file but to be honest I don’t think I’ve done it correctly, just kept hitting the expand button on the columns. If someone could lay out a great process to bring this in that would be awesome.
From the BOM
The data I suggest you use is called our Australian Digital Forecast Database (ADFD). This provides forecasts for the next seven days and is used in all the Bureau’s standard forecast products.
ADFD data (a subset) is visualised in MetEye: http://www.bom.gov.au/australia/meteye/
There is also a location dashboard where you can get tabular details for any location: http://www.bom.gov.au/places/vic/northcote/forecast/detailed/
As discussed, this is gridded data in NetCDF format. Samples are here: ftp://ftp.bom.gov.au/anon/sample/catalogue/ADFD/
Info on parameters available, filenames and other technical details are in the user guide: http://reg.bom.gov.au/catalogue/adfdUserGuide.pdf
I provided a link to a sample file for our live weather station data before, but here it is again for completeness: ftp://ftp.bom.gov.au/anon/sample/catalogue/Observations/IDN60920.xml
As you have geospatial capability you may wish to have a look at our GIS2Web service: http://reg.bom.gov.au/catalogue/GIS2Web.pdf. This is intended for ‘situational awareness’ so doesn’t contain forecast information, but has a good range of current conditions layers, including all major Bureau warning types.