How to Load Weather Data into Microsoft Excel using a Web Query Data Connection

One of the powerful features of the Visual Crossing Weather Service is the ability to query data via a Web Service or URL.  This ability isn’t only limited to coders but rather can be utilized to import data into most Business Intelligence Systems including Excel.   When you include your data into Excel, you can refresh …

Weather Data Conditions

The Weather APIs include a ‘conditions’ field which represents a summary of the key weather features for a particular weather record (be it daily, hourly or subhourly record). How is the condition field calculated? The weather conditions field is created by examining the weather that will be or was experienced during that weather record. If …

How to include sunrise, sunset, moon phase, moonrise and moonset data into your API requests

In addition to providing historical weather observations and weather forecast data, the Weather API also provides astronomical information. This astronomical information includes sunset, sunrise and moon phase data. Why is astronomical information useful? Sunset, sunrise and moon information goes hand-in-hand with weather data in many use cases. The information can help answer some basic questions: …

How can I load weather forecast data into Microsoft Power BI?

In this article, I’m going to show how you can quickly and easily load weather forecast data for any worldwide location into Microsoft Power BI for further analysis.  Visual Crossing Weather enables you to import forecast or historical weather data into Power BI. The data can be imported as CSV or JSON depending on your …

Agriculture elements in the Timeline Weather API

The Timeline Weather API includes elements that are designed for use by the agricultural and horticultural industries. These elements are designed to providing weather data that influence those who grow plants or raise livestock. The elements on this page are available only to certain subscription levels. For more information, please see our pricing page. The …