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

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

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?
  - Robbief
    Helper II
    9 years ago
    Could you Publish the PBIX file for us to re-use?
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.