topic Re: How to: Build a Weather Dashboard with API and Parameters in Data Stories Gallery

How to: Build a Weather Dashboard with API and Parameters

cpinho — Wed, 18 Jan 2017 17:24:58 GMT

Hi, just created this dashboard connecting local data and 2 API calls for current weather and 5 days forecast.

This is my first public dashboard and tutorial. Hope you enjoy.

How to: Create a Weather Dashboard with Power BI and API

eyJrIjoiMTM1ZTVlNjItNmRiNC00NjQzLTg2NWQtNDM1ZmYwYzM5YTllIiwidCI6ImQ1MWRlNTk2LTQ1YTAtNGFhNS1hMGQ4LTQ3ZDFjOTU4YWEzMiIsImMiOjh9

Re: How to: Build a Weather Dashboard with API and Parameters

musicbydannyd — Wed, 18 Jan 2017 18:29:33 GMT

It's pretty humid in NY! ;-)

Re: How to: Build a Weather Dashboard with API and Parameters

cpinho — Thu, 19 Jan 2017 00:19:44 GMT

Indeed! over 100% ;-)

Thank you for enjoying.

Re: How to: Build a Weather Dashboard with API and Parameters

musicbydannyd — Thu, 19 Jan 2017 14:35:02 GMT

Would you be interested in swapping one of my weather .pbix file (using wunderground.com) for yours?

Re: How to: Build a Weather Dashboard with API and Parameters

musicbydannyd — Thu, 19 Jan 2017 22:42:35 GMT

Your blog is restricted at my company, so I'm posting my weather query file here for all to enjoy! :) Sorry for the extra (bonus?) tables as this was a part of a golf rounds report.

To use weather in your area (I beleive it's US only), replace 'KGAEATON6' in the query text with the station ID from your local station... find it at www.wunderground.com (I beleive it's US only) by typing in your city/state or zip code.

Re: How to: Build a Weather Dashboard with API and Parameters

cpinho — Tue, 24 Jan 2017 09:32:39 GMT

I've sent you via email the pbix file. Hope it helps. In the meantime, checking your file. It seems is returning some errors. Believe is due to relationships. Although hadn't yet time to check it closely. Will get back to you ASAP.

Best

Carlos

Re: How to: Build a Weather Dashboard with API and Parameters

musicbydannyd — Tue, 24 Jan 2017 14:13:48 GMT

Still no email. :-( But thanks for trying!

The errors may have to do with the calendar updating before the rest of the data... try a refresh.

Re: How to: Build a Weather Dashboard with API and Parameters

cpinho — Thu, 26 Jan 2017 17:48:22 GMT

I will check it asap.

Re: How to: Build a Weather Dashboard with API and Parameters

asanghi — Sun, 05 Mar 2017 23:32:21 GMT

Whenever I enter the data source (e.g., http://api.openweathermap.org/data/2.5/forecast/city?id=4922388&APPID={xyz}) I get a prompt with 'Access web content The user was not authorized'? Do you know why? I entered my api key correctly. Screenshot attached.

Re: How to: Build a Weather Dashboard with API and Parameters

cpinho — Mon, 06 Mar 2017 14:13:53 GMT

Hi asanghi,

can you publish you pbix file pls?

Re: How to: Build a Weather Dashboard with API and Parameters

Robbief — Thu, 13 Apr 2017 11:24:48 GMT

Could you Publish the PBIX file for us to re-use?

Re: How to: Build a Weather Dashboard with API and Parameters

cpinho — Thu, 13 Apr 2017 14:12:05 GMT

Hi,

Sure. Here it is.

Let me know.

Best

Carlos Pinho

biitlog.com

Re: How to: Build a Weather Dashboard with API and Parameters

Robbief — Thu, 13 Apr 2017 14:12:51 GMT

CHEERS!

Re: How to: Build a Weather Dashboard with API and Parameters

markive — Mon, 12 Feb 2018 03:41:34 GMT

I did a similar proof of concept..

In case it helps anyone, in order to get historical data I used Azure Table Storage and an Azure Function to get the weather at a set interval and log it to Azure Table Storage. I then query that instead of the API for the historical data.

Re: How to: Build a Weather Dashboard with API and Parameters

cosminc — Tue, 24 Apr 2018 15:49:55 GMT

can you help me please? i'm a little bit stuked

on the step with the import of api in Power BI i have an issue, please see the attachement.

it apprears after the step Get Data-Web-and paste the link http://api.openweathermap.org/data/2.5/weather?id=5128581&units=metric&appid={key id}

Thanks a lot!

Cosmin

Re: How to: Build a Weather Dashboard with API and Parameters

cpinho — Wed, 25 Apr 2018 11:31:19 GMT

Hello cosminc

You should chose the web API , so that the key you are parsing on the URL is authentication you are going to use.

Let me know if it helps.

Best

Carlos

Re: How to: Build a Weather Dashboard with API and Parameters

Anonymous — Thu, 03 May 2018 12:37:41 GMT

Hello Carlos Pinho,

After changing the data source as API source, I'am getting an error "We couldnt authenticate with the credentials provided".

I have changed the privacy settings also for the current file.

Please help

Re: How to: Build a Weather Dashboard with API and Parameters

cosminc — Wed, 16 May 2018 12:15:00 GMT

Hi Carlos

first of all sorry that i give you feedback so late, i was busy with other projects.

the API key wasn't put right by me, the support from the site gave me the right syntax.

now i want to take data - historical (last 2 weeks)+5 day forecast+current day

do you have any idea how to make import pictures - from what columns and how to to this in power bi

i want to obtain for last 2 weeks+current day+3 days forecast - a picture for each day with sun/rain like on tv:) and bellow to put daily temperature and precipitations (% form 100% chances) or maybe you have a suggestion

thanks

Cosmin

Re: How to: Build a Weather Dashboard with API and Parameters

cosminc — Thu, 17 May 2018 15:33:33 GMT

I found on topic an example and understood how to solve my issues.

the main issue is that i need historical data last 2 weeks and on openweathermap.com are not free

Re: How to: Build a Weather Dashboard with API and Parameters

cosminc — Mon, 21 May 2018 16:47:10 GMT

Hi,

did you how to store the weather data and to create a historical base?

Many thanks,

Cosmin