How to: Build a Weather Dashboard with API and Parameters

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: ...

how to

Technology

cpinho
9 years ago
Hi,

Sure. Here it is.

Let me know.

Best

Carlos Pinho

biitlog.com
ws.pbix9 MB

musicbydannyd

Advocate IV

9 years ago

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

musicbydannyd

Advocate IV

9 years ago

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.

wunderground query.pbix16.9 MB

cpinho
Advocate I
9 years ago
Hi

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
- asanghi
  Regular Visitor
  9 years ago
  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.
  - cpinho
    Advocate I
    9 years ago
    Hi asanghi,
    
    can you publish you pbix file pls?
- musicbydannyd
  Advocate IV
  9 years ago
  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.
  - cpinho
    Advocate I
    9 years ago
    I will check it asap.