6/12/2023 0 Comments Import and visual json dataAs Power BI also supports Power Query, you can also use these same concepts to import data into Power BI. ![]() Now that we have our Weather API query, we can start creating the Power Query script that will import the data into Excel. Here is sample of the data: Example JSON output of the Weather APIįor full documentation on this Weather API, head over to the full Timeline Weather API documentation. The above API request returns JSON formatted data. The items in bold are parameters for the location, date range and units of measurement – we will add a way for the user to modify these easily. Paris,France/ /?unitGroup= us&key= YOUR_API_KEY Here’s the sample weather API request we will model our Power Query Script around: We will be using the Timeline Weather API that provides seamless access to historical and forecast weather. In addition to creating your account, you can also create sample Weather API queries. To do this, head over to the Weather Data Services page. Before we can use the API, we have to create a free account. This free API provides simple access to historical weather data as well as weather forecast. We are going to use the Visual Crossing Weather API. Step 1 – Choose an API and create a sample query Add parameters to the Power Query script so that we can make changes in Excel and have the data update automatically. ![]()
0 Comments
Leave a Reply. |