cpinho's avatar
cpinho
Icon for Advocate I rankAdvocate I
9 years ago
Solved

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
cferraz_hemav's avatar
cferraz_hemav
Icon for Helper I rankHelper 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's avatar
markive
Icon for Advocate II rankAdvocate 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.