Bring weather data into Power BI using the Web Query Connections. With just a few clicks, users can paste in a URL query string and pull Historical Weather, 15-day Weather Forecast or Historical Climate Data into any report or dashboard. The Visual Crossing Web Query Feed is fully integrated with the Web Query functionality and provides a Weather Query URL Builder that allows users to construct weather queries from an easy-to-use interface. Power Query users can take advantage of the parameterized query support allowing report users to easily enter in their own locations, dates and more without modifying the query string.
Integrated Weather Data in Microsoft Power BI
Integrate weather data using web query or file import
The most common method for getting data into Power BI is by opening a saved data files. Visual Crossing’s Data Services allows users to build the weather query they want and with a click of a button they can download their weather data file directly to their desktop. Our CSV file format is 100% compatible with Power BI's File Import functionality. Users can easily take weather data with them, share with colleagues or create a shareable data store.