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

Hi, Sure. Here it is. Let me know. Best Carlos Pinho biitlog.com

How to: Build a Weather Dashboard with API and Parameters

25 Replies

musicbydannyd
Advocate IV
9 years ago
It's pretty humid in NY! ;-)
- cpinho
  Advocate I
  9 years ago
  Indeed! over 100% ;-)
  
  Thank you for enjoying.
  - musicbydannyd
    Advocate IV
    9 years ago
    Would you be interested in swapping one of my weather .pbix file (using wunderground.com) for yours?
cosminc
Post Partisan
8 years ago
Hi

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
- cpinho
  Advocate I
  8 years ago
  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
  - cosminc
    Post Partisan
    8 years ago
    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
cferraz_hemav
Helper I
5 years ago
Hi friends!

I'd like to have a report that uses lat and long from one source and uses these parameters to perform one query to the weather provider. In addition the source of lat-long could vary from one week to another so I want this to be dynamic. Is there a way to do this?
Let's say we have this table as an input:

element_id | element_name | long | lat

48087 PORTELLA31086 0.5484911794190 42.2340858391
48088 OBAGA310811 0.5452424355600 42.2364303825
48089 PAUL310812 0.5429963973033 42.2362877305
48090 BOGA Y ROCA310814 0.5564795968214 42.2347207445
48091 MASIA310818 0.5518679290601 42.2373370319

Thanks!
- markive
  Advocate II
  5 years ago
  Hi cferraz_hemav ,
  
  I'm not sure you will be able to configure an API request to a weather API to be made dynamically as a Direct Connect datasource in PowerBI.
  
  Therefore the way I would do it is to create a Microsoft Flow or Logic App to loop through your dataset of lat/lng and then get the weather data and save it to a datasource like a Google Sheet or database. Then you will just join this extra datasource into your model. You will also have historical data for all these coordinates. You will just need to make sure yo don't hit API limits.
- cpinho
  Advocate I
  5 years ago
  If you want to store historical data, than you need to do this outside PBI. You use services as Flow or IFTT (several weather providers are available). You store the data in a excel or txt, and use it as a source to your pbi file too.
Rebel
New Member
3 years ago
Hi Carlos
Your tutorial link isn't working can you please upoad the correct link.
Thank you
Rebel